topic Nested variables are not working in StraightTable (Without selecting any value) in QlikView

Nested variables are not working in StraightTable (Without selecting any value)

Wed, 15 Feb 2012 09:13:19 GMT

Hi All,

I am using approximately 50 variables in my application.One variable is dependent on the other one. When a value is selected,the reult is displayed propely(Chart/Table).But I need to diaplay the data in a table without selecting any value.

Any idea how to achieve this? Thanks

Nested variables are not working in StraightTable (Without selecting any value)

deepakk — Wed, 15 Feb 2012 10:08:45 GMT

hi,

As per my understanding , the variable concept will not work. Because variable can store only single value.

Hence when you write an expression inside variable, it summarize the value and stores in it. Hence when you are selecting the certain values , it again summarize the data and store inside that.

Data Amt

A 10

B 20

C 20

eg: Variable1 = Sum(Amt) . Variable1= 50

if variable used inside pivot table

A 50

B 50

C 50

And when you select A . It will store A= 10

A 10.

I hope you are clear with the issue.

If you can attach some sample, we can try out other alternative methods.

Deepak

Nested variables are not working in StraightTable (Without selecting any value)

Wed, 15 Feb 2012 16:30:39 GMT

Yes Deepak you are correct. Now can understand the issue in my application. Thanks Deepak.