topic Filtering a Graph Using a Variable in QlikView

Filtering a Graph Using a Variable

richnwide — Fri, 28 Feb 2014 08:46:16 GMT

Hello,

I'm new to this, so apologies in advance if this is very straightforward:

I've created a bar chart which shows revenue against a time period. For simplicity of loading, I've combined the Month to Date and Year to Date figures in one table, so the data is like the following.

Date Period Revenue

1 10

2 15

3 20

4 15

Jan 300

Feb 280

Mar 340

The graph currently displays all data together

I have a toggle button which changes a variable so it shows either 1 (MTD) or 2 (YTD). My aim is when the variable = 1 that it only shows the MTD information, ie 1,2,3,4,etc and when it = 2, it only shows the YTD information, ie, Jan, Feb, etc.

Is this possible?

Thanks in advance.

Re: Filtering a Graph Using a Variable

Fri, 28 Feb 2014 09:11:07 GMT

Hello,

you could try the following. Set conditionals for your Dimensions under the Bar Chart Proporties.

For MTD insert "=if('yourVariable' = 1,0,1)" and for YTD insert "=if('yourVariable' = 0,0,1)". If you then click the Button your Bar Chart should change. Let me know if this helps you.

Best Regards,

Steven

Re: Filtering a Graph Using a Variable

Fri, 28 Feb 2014 12:41:20 GMT

You need to add one more field as identifier to identify MTD or YTD. I have add 'display' field.

Re: Filtering a Graph Using a Variable

Fri, 28 Feb 2014 12:44:01 GMT

See qvw file.

Vinay

Re: Filtering a Graph Using a Variable

richnwide — Fri, 14 Mar 2014 10:07:01 GMT

Hello,

I tried Steven's solution without success - which is probably down to me lack of knowledge rather than the solution not being right as it seems like it should work. I then tried Vinay's and that seems to have done the trick.

Thanks to both of you for your suggestions

Rich

Re: Re: Filtering a Graph Using a Variable

jsingh71 — Fri, 14 Mar 2014 11:00:37 GMT

Hi Rich,

I developed two sample application as per your need. you can use which ever you want.

Find it in attachment.