Transform 0 as Null under specific condition

Thu, 12 May 2016 04:03:29 GMT

Hello Community,

I am now doing a combo chart and encounter a problem related to the line. There 2 dimensions in the graph, one is the Period, another is the Scenario. Scenario is divided into Actual ('A') and Plan ('P') data, which is required to show in the bars. However, for the line, it is only required to show the 'A' figure rather than both 'A' and 'P' and I did it by getting 'A' data with set analysis. From the picture below, you can tell the outcome is a bit strange because 'P' is shown as 0 through the line for each period, and that is not what I expect to see.

I have tried to use the suppress 0 function but it may affect the bar chart part to show 0, so suppress 0 function is not a solution for my problem. How can I fix this?

Thanks

Maverick

Re: Transform 0 as Null under specific condition

avinashelite — Thu, 12 May 2016 13:30:23 GMT

Try with if condition like

if(Scenario='P',null(),your set analysis expression for A)

Re: Transform 0 as Null under specific condition

swuehl — Thu, 12 May 2016 13:47:36 GMT

Try something like

Sum(TOTAL<Period> {<Scenario = {'A'}>} Value)

topic Transform 0 as Null under specific condition in QlikView

Transform 0 as Null under specific condition

Re: Transform 0 as Null under specific condition

Re: Transform 0 as Null under specific condition