topic Re: Set Analysis in a 2 dimensional stacked bar chart. in QlikView

Set Analysis in a 2 dimensional stacked bar chart.

Thu, 02 May 2013 17:33:09 GMT

All,

I have a stacked bar chart with two dimensions in it, one being LOG_MONTH and the other being OPERATOR_CODE. My expression is SUM(LOGGED_VALUE). What I'm trying to acheive is to check for null values in LOGGED_VALUES and if found then use the previous month's LOGGED_VALUE. I can't seem to write the correct set analysis for this one. Any help?

Re: Set Analysis in a 2 dimensional stacked bar chart.

shree909 — Thu, 02 May 2013 18:26:38 GMT

Hi ,

in the expression u need to write an if condition

first create variable for previous month and use that varaible in the set analysis

if(logged_values =null() or isnull(loggedvalues) or len(trim(logged_values))=0, sum({<Month ={'$(vpreviousmonth)'>}loggedvalue),sum loggedvalue)