topic Re: Hide chart when blank value captured in QlikView

Hide chart when blank value captured

Anonymous — Thu, 02 Mar 2017 05:39:44 GMT

I have set of data where I need to hide the chart when ever the data has null values .

In the given sample application no data is present for 2017 and in 2018 north region data ,so the chart should not be visible whenever

the null values are present in the chart

Re: Hide chart when blank value captured

tresB — Thu, 02 Mar 2017 05:52:41 GMT

Layout->Show Conditional expression: Rangesum(Sum(Amt),Sum(SALES), sum(Order))

Re: Hide chart when blank value captured

Anonymous — Mon, 20 Mar 2017 10:55:56 GMT

Is it possible to implement the same ,if we are using calculated dimension using valuelist function in dimension and expression and using sum function instead of count

Re: Hide chart when blank value captured

Anonymous — Fri, 24 Mar 2017 04:57:30 GMT

Thanku very much treseco for your reply.very well appreciated