topic Re: select dynamic input for a graph in QlikView

select dynamic input for a graph

Thu, 23 Apr 2015 15:33:51 GMT

Hello All,

I have a table containing transaction data for multiple quarters (which can be identified by a transaction date associate with it). I want to create a graph comparing any 2 quarters in the data but I want to give user a choice to select the quarters to compare may be using radio buttons. How do I go about this? I couldn't find an example which will help me to implement such a functionality.

Thanks

Re: select dynamic input for a graph

sunny_talwar — Thu, 23 Apr 2015 16:20:09 GMT

What would be the dimension you would be comparing them on? is it going to be quarter or some other dimension like country, state, etc..

Best,

Sunny

Re: select dynamic input for a graph

Thu, 23 Apr 2015 16:24:33 GMT

my dimension will be product ID and one of the graphs will be comparing the sales per quarter another will be change in price.

Re: select dynamic input for a graph

sunny_talwar — Thu, 23 Apr 2015 16:26:35 GMT

You can try to employ the concept of alternate states. Take a peek at the attached sample.

Best,

Sunny

Re: select dynamic input for a graph

buzzy996 — Thu, 23 Apr 2015 16:34:37 GMT

try this way,sample attached.

u have to create 2 variables,

List box: Variable1--define listed values in list box(in ur case Q1,Q2,Q3,Q4)

List box: Variable2--define listed values in list box(in ur case Q1,Q2,Q3,Q4) (SAME VALUES)

use those variables in ur expressions,to render dynamic values from ur selections

Re: select dynamic input for a graph

Thu, 23 Apr 2015 18:52:30 GMT

Hi Siva,

thanks for this example, it is very close to what I want. Defining 2 variables and using them to change the input is something I was looking for! Now, I am trying a plot a graph for change in mVal by pVal as seen in attached example. i had the exact same graph before I started implementing the dynamic selection but for some reason I couldn't get this to work using the dynamic drop down for quarter selection. Any thoughts?

Re: select dynamic input for a graph

sunny_talwar — Thu, 23 Apr 2015 19:09:05 GMT

Does this look like something you are trying to do? (PFA)

Best,

Sunny

Re: select dynamic input for a graph

buzzy996 — Fri, 24 Apr 2015 09:11:05 GMT

see attached and let us know,if u need any changes..,the problem with expression,i just replaced sunny exp here.

Re: select dynamic input for a graph

Wed, 06 May 2015 16:05:51 GMT

Edi: NVM it worked!

Hi Sunny,

This worked perfectly! Now one more question for the calculated dimension -

=Sum({<Quarter = {'$(vQuarter1)'}>}MValue) - Sum({<Quarter = {'$(vQuarter2)'}>}MValue)

For the above expression can I add one more set expression (Year) as follows:

=Sum({<Quarter = {'$(vYear1)'}>}{<Quarter = {'$(vQuarter1)'}>}MValue) - Sum({<Quarter = {'$(vYear2)'}>}{<Quarter = {'$(vQuarter2)'}>}MValue)

Re: select dynamic input for a graph

sunny_talwar — Wed, 06 May 2015 16:09:43 GMT

How can Quarter be equal to year? What exactly are you trying to do? Would you be able to give an example?

Re: select dynamic input for a graph

Wed, 06 May 2015 16:26:29 GMT

so the table has data worth multiple years and I want the user to be able to select any 2 quarters for comparison (i.e. any 2 quarters from any 2 years). So I have 4 drop-down input boxes containing pre definied values of years and quarters. User can then select year and quarters respectively and the graph will update according to user's selection. Does that make sense?

Re: select dynamic input for a graph

sunny_talwar — Wed, 06 May 2015 16:29:04 GMT

Try this:

=Sum({<Year = {'$(vYear1)'}>}{<Quarter = {'$(vQuarter1)'}>}MValue) - Sum({<Year = {'$(vYear2)'}>}{<Quarter = {'$(vQuarter2)'}>}MValue)

Re: select dynamic input for a graph

Wed, 06 May 2015 16:36:32 GMT

oh, that is exactly what I did but didn't realize I had quarter = year in the previous post, forgot to update that while posting!

Re: select dynamic input for a graph

sunny_talwar — Wed, 06 May 2015 16:38:55 GMT

Ya that should work in theory for a comparison such as:

Year = 2015 Quarter = Q1 vs Year=2014 Quarter= Q1 or

Year = 2015 Quarter = Q2 vs Year=2015 Quarter= Q1

If this is the kind of comparison you are looking for, then this should def. work.

Best,

Sunny

Re: select dynamic input for a graph

Thu, 14 May 2015 17:54:12 GMT

Set expression definitely worked here and I have slightly modified the code so that I have one field 'YearQuarter' instead of 2 fields year and quarter. So the updated set expression looks like this

=Sum({<YearQuarter= {'$(vYearQuarter1)'}>}MValue) - Sum({<Year = {'$(vYearQuarter2)'}>}MValue)

Now I want to include a filter (slider object) to filter values on X axis i.e. my slider should read min(above expression) to Max(above expression) but when I try to use min and max on the above expression I get garbage value error. Am I missing something here? Could someone please help me with this issue?

thanks!

Re: select dynamic input for a graph

sunny_talwar — Thu, 14 May 2015 17:57:42 GMT

I feel that since this is a new question that you are asking why don't you start a new thread with an example??? It would be probably easier for people to see the issue at hand and you can always give a link to this thread if they want to see more details.

Just a thought

Best,

Sunny

Re: select dynamic input for a graph

Thu, 14 May 2015 18:02:52 GMT

I am actually creating a new thread as well but wanted to post here since this thread has more background information.