Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Pulkit_Thukral
Partner - Creator II
Partner - Creator II

Using above function in Bar/Line Chart

Hi,

PFB Screenshot on which my complete development is based:-

Pivot.PNG

In the above table,i am using 2 dimensions-Month and StorageType(HUS or VSP), others are expressions.

Expression 1 uses a above function with complete expression:-

if(month ='Jul',if(storage_type='VSP','1083','178'),

above([Capacity Baseline-Storage])+above(BAU)+above(SCR)+ above(Reclaim))

This gives perfect result as shown in the above table.

BUT, when the same table is converted to a Bar/Line chart, it gives me only the first (default 'hard coded' value for the month of july).

PFB Screenshot:-

Barnlinegraph.PNG

How can i get same figures in this chart as were coming in pivot table.

What extra do we have to use in the expression.

1 Reply
Pulkit_Thukral
Partner - Creator II
Partner - Creator II
Author

Have i made the requirement clear guys?

i request urgent help in this matter.