topic Cross Table Concept in QlikView

Cross Table Concept

abhaysingh — Wed, 29 Apr 2015 04:47:43 GMT

Hi all,

i have one value field, which is made after using cross table and values are repeating.. how i can make these repeated values distinct?

regards

Abhay

danieloberbilli — Wed, 29 Apr 2015 05:04:40 GMT

you would have to load it in another logical table like:

Cross1:

Crosstable(attribute,data,2) load

ID,

Category,

F1_1,

F1_2,

F1_3

resident Data;

CategoryDist:

Load distinct

Category as Category_distinct

resident Cross1;

abhaysingh — Wed, 29 Apr 2015 05:11:33 GMT

Hi Thanks for revert,

but i want to have distinct value like outstanding values... and after resident what should i do ?? will do concatinate with resident table?

thanks

danieloberbilli — Wed, 29 Apr 2015 05:18:55 GMT

Not sure what you try to achieve.

If you would like to have distinct values in your crosstab - that won't work as you would loose information.

imagine

ID Category attribute data

1 A F1_1 100

1 B F1_2 50

2 A F1_1 30

2 B F1_2 75

If you would try to enforce a distinct value within that table - you would loose all information