topic How to add two straight table values to a graph in QlikView

How to add two straight table values to a graph

Wed, 07 Dec 2011 00:04:04 GMT

I have two straight tables which I display only the totals by hiding other columns and rows. These totals are a result of several complecated expressions involving 'Above function' and 'Sorting', hence cannot be recreated in the graph expressions. I want to get these two total values to a bar graph. Can I reference these totals outside the straight table? i.e. in a variable?

Any ideas?

How to add two straight table values to a graph

Wed, 07 Dec 2011 08:01:15 GMT

Can I have the demo application sot that I can exactly tell you how to do it.

But for simply try to use all the those expression as one and implement it in the Bar Chart.

Or you can also do one thing that in bar chart there feature of the "Invisible". Try to use that feature.

Regards,

Nitin Jain

How to add two straight table values to a graph

Thu, 08 Dec 2011 00:11:05 GMT

Thanks Nitin.

I'm not sure how to implement an expression like below in the bar expression, because it uses Above function which relies on sort order of the table.

if((SEL_MapZoneGuid-Above(TOTAL SEL_MapZoneGuid))>0 and (TRIPEVENT-above(TOTAL TRIPEVENT))=1,1,0)

A quick workaround I found is to use VB scripts to load the table values into variables and use them in the bar graph.