topic Show and Hide Chart in QlikView

Show and Hide Chart

abhijain — Fri, 12 Oct 2012 05:05:40 GMT

Hello,

Please suggest me how to show my chart on the basis of only previous two months selections with respect to the current year and else hide my chart.

Re: Show and Hide Chart

Siva_Sankar — Fri, 12 Oct 2012 05:39:00 GMT

You assign a value to a variable that contains the condition you wish to evaluate. Button Properties Actions->Add Action->External Set Variable Then within the chart properties Layout tab -> Show -> Conditional, you write an expression and check the value of the variable.

Re: Show and Hide Chart

Fri, 12 Oct 2012 07:06:22 GMT

Hi,

Maybe you could check this one.

The attached file shows that whenever you choose previous 2 months based on current year, the chart will show up, else the chart will hide.

Regards,

Janzen

Re: Show and Hide Chart

abhijain — Fri, 12 Oct 2012 08:10:42 GMT

Hi,

Thanks but i want that chart should hide when current year is no selected as i want to show the chart when only current year and previous two months are selected.

Re: Show and Hide Chart

Fri, 12 Oct 2012 10:17:46 GMT

Hi,

Please see updated.

Regards,

Janzen

Re: Show and Hide Chart

abhijain — Sat, 13 Oct 2012 08:35:50 GMT

Thanks for ur support but actually on selections of year and month i want the chart to get displayed or hide .And i dont need buttons

Re: Show and Hide Chart

Gysbert_Wassenaar — Sat, 13 Oct 2012 11:36:39 GMT

Here's a version that does what you want:

Re: Show and Hide Chart

abhijain — Tue, 16 Oct 2012 03:37:53 GMT

I want that chart should only be shown when current year and only previous two months are shown

Re: Show and Hide Chart

vlad_komarov — Tue, 16 Oct 2012 03:45:49 GMT

If I got it right: you want to show your chart only if you have last two months selected in your calendar, correct?

You can create few flags in your Calendar table:

,if (((monthstart($(vToday), -3) <= FullDate) and (monthstart($(vToday), 0) > FullDate)), 1, 0) as Last2MonthsFlag

,if (inyeartodate(FullDate, date($(vToday)), 0), 1, 0) as CYTD_Flag // current Year-to-Date

and use these flags to show/hide your chart.

Good luck,

Vladimir

Re: Show and Hide Chart

abhijain — Wed, 17 Oct 2012 08:48:26 GMT

Actually i need to add the expression in the chart layout itself. Now the problem is when i select current year and a previous month the chart appears but when i select current year and two previous month the chart disappears but i want that chart should appear in this case also when i select current year and more the one previous month together.