topic Re: Expression Conditional Show in QlikView

Expression Conditional Show

Wed, 13 Jan 2016 07:17:45 GMT

Hi All

I created a chart and activated expression conditional show to switch between YTD and MTD. However when I now select a single record the chart give me a result of 0 even if there is a value.

What’s causing this and how can I fix it?

Re: Expression Conditional Show

Anonymous — Wed, 13 Jan 2016 07:36:31 GMT

Hi Tumelo,

I see that you have used a variable. I would suggest that you set the value of the variable in your script as 1 or some other number. Then, in the conditional statement, set the variable to 0. Also set the charts associated with the condition value.

I hope this helps

Re: Expression Conditional Show

NareshGuntur — Wed, 13 Jan 2016 07:36:39 GMT

The dashboard is showing correct data.

I just have selected Budget Month as 'Jan - Feb' where YTD amount is 0.

and I see no Amount in the below table.

When you clear the selections, even the top chart shows data other than 0s. Please scroll down.

Cheers,

Naresh

Re: Expression Conditional Show

jagan — Wed, 13 Jan 2016 07:40:37 GMT

HI,

The variable declaration is causing the issue

vTransMaxMonth=MaxString({<Amount={">0"}, Year={'$(vMaxYear)'}>}BudgetMonth)

Try this expression

=MaxString({<Amount={">0"}, Year={'$(vMaxYear)'}> + <BudgetAmount={">0"}, Year={'$(vMaxYear)'}>}BudgetMonth)

Regards,

Jagan.

Re: Expression Conditional Show

udaya_kumar — Wed, 13 Jan 2016 07:42:44 GMT

Check this file

Re: Expression Conditional Show

Wed, 13 Jan 2016 07:58:20 GMT

Hi Uday

This is exactly what I want, how did you get this to work correctly?

Re: Expression Conditional Show

Wed, 13 Jan 2016 08:10:46 GMT

Hi guys

Thanks for all your replies. Uday posted an app with the correct result but I still don't understand what he did differently...

Re: Expression Conditional Show

Wed, 13 Jan 2016 08:16:02 GMT

Oooh....got it! Never mind Thanks

Re: Expression Conditional Show

jagan — Wed, 13 Jan 2016 08:17:36 GMT

Did you checked for MTD & Category = Airtime? The same issue displaying zeros.

Did you tried this

vTransMaxMonth=MaxString({<Amount={">0"}, Year={'$(vMaxYear)'}> + <BudgetAmount={">0"}, Year={'$(vMaxYear)'}>}BudgetMonth)

Please find attached file.

Regards,

jagan.