topic Re: Repetitive values in pivot table in QlikView

Repetitive values in pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a pivot table where certain expressions have to used as dimensions and only monthly counts have to be displayed as expressions. The dimension values are repeating. can someone please help me fix this? thanks!

Re: Repetitive values in pivot table

pradosh_thakur — Thu, 28 Dec 2017 19:38:03 GMT

Why do you need to show them as dimensions ? You can chnage the positions of expressions to put it in any order.

can you provide some more detail? its not clear with the info you provided.

Re: Repetitive values in pivot table

Anonymous — Thu, 28 Dec 2017 19:43:22 GMT

Thanks for your prompt response Pradosh!

All these columns on to the left.. users want those to be static and jus the month values, they should be able to choose dynamically from the filters. Meaning first 6 columns should always b there where as the next columns can change based on the selections made.

Re: Repetitive values in pivot table

hallquist_nate — Thu, 28 Dec 2017 20:17:26 GMT

If the calculations need to be used as dimensions, and they should not change when making selections, then calculate them in the script and then you can display them as Dimensions. Be careful though, they will be static and won't change with selections, so do not sure those values in Calculations in charts, because they won't be right.

That is what I would do. I would create an LOB dimension called Users, Total all files Jan-Dec, Total Docs, Total Individual WS, and Total Emails.

Good Luck,

Nate

Re: Repetitive values in pivot table

Anonymous — Thu, 28 Dec 2017 20:48:15 GMT

Thanks for your response Nate.

Sorry for not being clear.

Values has to change based on the selections/filters. But the columns Users, Total all files Jan-Dec, Total Docs, Total Individual WS and Total Emails should retain its position.

No selections made: displays latest 6 months data

When May and June months are selected:

All I'm trying here is NOT to display the same values over and over in these 5 columns.

Re: Repetitive values in pivot table

pradosh_thakur — Fri, 29 Dec 2017 02:07:01 GMT

sure..

we would help you with that. any sample qvw.data woule be good to work on .

Re: Repetitive values in pivot table

PrashantSangle — Fri, 29 Dec 2017 06:58:02 GMT

Hi,

What I understand from your attached image is Data is not repeating. There LOB was different.

change sequence of LOB Demote it to last.

Regards,

Prashant Sangle

Re: Repetitive values in pivot table

Anonymous — Fri, 29 Dec 2017 14:27:11 GMT

Added a sample.qvw to my original post.

Please take a look.

I would really appreciate your help! Thanks!

Re: Repetitive values in pivot table

Anonymous — Fri, 29 Dec 2017 14:32:21 GMT

When I demote LOB to the last, this is how it looks

But the requirement is to display LOB and other columns first and then the columns Users, Total all files Jan-Dec, Total Docs, Total Individual WS and Total Emails followed by monthly counts where the display of months can change based on selections.

Please let me know if you need any other information.

I would really appreciate your help! Thanks!

Re: Repetitive values in pivot table

PrashantSangle — Tue, 02 Jan 2018 06:57:03 GMT

Can you show us how you want to present your data w.r.t above input data???..

Regards,

Re: Repetitive values in pivot table

avinashelite — Tue, 02 Jan 2018 07:09:36 GMT

from the dimension suppress null values ...i could see the values are repeating because you have null values in the dimension

Re: Repetitive values in pivot table

Anonymous — Tue, 02 Jan 2018 22:11:04 GMT

I did suppress the null values and it didn't help

Re: Repetitive values in pivot table

Anonymous — Tue, 02 Jan 2018 22:26:02 GMT

Hi Prashant,

I'm trying to display same values in both straight table and pivot table.

But as you see in below screenshots, pivot table is jus displaying the totals in each row. \

Please see the sample.qvw attached to my original post.

I would really appreciate your help on this.

Re: Repetitive values in pivot table

PrashantSangle — Wed, 03 Jan 2018 06:12:26 GMT

If possible share your file...

Re: Repetitive values in pivot table

Anonymous — Wed, 03 Jan 2018 14:46:34 GMT

‌please find my qvw attached to the original post all the way on the top. Thanks!

Re: Repetitive values in pivot table

PrashantSangle — Thu, 04 Jan 2018 05:51:45 GMT

missing attachment.

Regards,

Re: Repetitive values in pivot table

kamalqlik — Thu, 04 Jan 2018 06:16:02 GMT

Please attach the QVW file so that we can have a look into it.