topic Re: Pivot table not showing correct data , but when it is reverted back to straight table, data is coming fine . Why ? in QlikView

Pivot table not showing correct data , but when it is reverted back to straight table, data is coming fine . Why ?

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

Hi All ,

Pivot table not showing correct data , but when it is reverted back to straight table data is coming fine for a particularly selected date .

Please find the attached qvw .

Thanks & Regards

Shekar

Re: Pivot table not showing correct data , but when it is reverted back to straight table, data is coming fine . Why ?

Chanty4u — Wed, 07 Mar 2018 12:50:32 GMT

try to add/remove dimensions and check for which it is giving cause?

by that you can able to understand why it is not giving?

Re: Pivot table not showing correct data , but when it is reverted back to straight table, data is coming fine . Why ?

stabben23 — Wed, 07 Mar 2018 12:50:44 GMT

You have no aggregation in Your Expression, This is information which should be Dimensions, thats why.

Re: Pivot table not showing correct data , but when it is reverted back to straight table, data is coming fine . Why ?

YoussefBelloum — Wed, 07 Mar 2018 12:52:26 GMT

Hi,

I don't know what you're trying to do, but comparing these 2 tables, on the pivot table you have your N dimension missing.

add your N dimension and you will see the same resultat as the one on the straight table

Re: Pivot table not showing correct data , but when it is reverted back to straight table, data is coming fine . Why ?

stabben23 — Wed, 07 Mar 2018 12:55:51 GMT

use maxstring or max on all Expressions and you will see some output here

Re: Pivot table not showing correct data , but when it is reverted back to straight table, data is coming fine . Why ?

stabben23 — Wed, 07 Mar 2018 12:58:32 GMT

Thats absolutely correct, N as Dimension is needed.

Re: Pivot table not showing correct data , but when it is reverted back to straight table, data is coming fine . Why ?

shekhar_analyti — Wed, 07 Mar 2018 13:00:15 GMT

Hi All ,

I did not get it . When seen in table box for that particular date we have data .

I have attached the qvw .

Re: Pivot table not showing correct data , but when it is reverted back to straight table, data is coming fine . Why ?

shekhar_analyti — Wed, 07 Mar 2018 13:06:51 GMT

Hi Johansson ,

As per your screenshot , there is only one data for that particular date , however we have two entries for that date , with values of N = 22 and 21 . I mean how to get both .

Re: Pivot table not showing correct data , but when it is reverted back to straight table, data is coming fine . Why ?

stabben23 — Wed, 07 Mar 2018 13:13:44 GMT

By adding N as dimension