topic query on pivot table in QlikView

query on pivot table

Tue, 06 Jul 2010 19:38:26 GMT

I've a pivot table in which i am populating the min value for one column, but I've another dimension for the same min value which also i want to get populated. CAn someone please help me in doing that.

DimensionA DimensionB

min (Dimension A)= 1 value corresponding to the min (Dimension A) = X

1 X

2 Y

3 Z

4 W

5 M

Now i want to find out a way to show the value corresponding to the min (Dimension A) which is X. couldn't get any way to do that.

can someone please help?

thanks in advance

query on pivot table

rwunderlich — Tue, 06 Jul 2010 23:27:38 GMT

If I understand the question correctly.

For the first dimension, use a calculated dimension of

=min(DimensionA)

For the seconds dimension, use a named dimension of

DimensionB

-Rob

query on pivot table

Wed, 07 Jul 2010 07:31:03 GMT

Hi Rob,

Thanks for your reply. but if you can please take a look at the screen shot below, the min(Dimension A) is coming as 77 but there is no values corresponding to 77 in column B. How can we get this resolved?

Thanks .