Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

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

2 Replies
Highlighted
Partner
Partner

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

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

Highlighted
Not applicable

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

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