topic Re: use listbox value as variable in set analysis in QlikView

use listbox value as variable in set analysis

Fri, 30 Nov 2012 07:02:41 GMT

Here's my thought:

when i choose the value of listbox,then my set Analysis will change according to the value.

for example:

China is one value of listbox,

when I choose China , Then the setAnalysis count({<Region = {'$(VriableName)'}>} distinct orderId)

will be count({<Region = {'China'}>} distinct orderId)

Or is ther any other method that i can realize this instead of using listbox?

Thank you!

Re: use listbox value as variable in set analysis

Anonymous — Fri, 30 Nov 2012 07:12:12 GMT

Well, if your region field is in a table connected to the order table already there wouldn't be any need for the variable/set analysis and picking 'China' as region would automatically narrow down your selection of orders to the ones related to China.

But I'm guessing you have some specific modelling issue you're trying to overcome using variables and set analsysis

Re: use listbox value as variable in set analysis

Fri, 30 Nov 2012 07:39:27 GMT

yes,I just used region as an example.

Actually my problem is : when user choose month 2012-08 then I need show 2011-08 also,

so I need to calculate in the set analysis.

Re: use listbox value as variable in set analysis

neha_shirsath — Sat, 01 Dec 2012 07:23:09 GMT

Hii,

See the attachment if it is helpful for u.

Re: use listbox value as variable in set analysis

Wed, 05 Dec 2012 05:37:41 GMT

hi, another quetion, if i choose month 2012/09/01, then i want to show the data of 2012/09/01

2012/08/01,2012/07/01 and 2011/09/01. (notice here is the month year ago)

How can i write the set analysis?

I kown how to get the continuous month

her is my set analysis:

count({<UsageCategory = {'LoginsDistribution'},UsageYearMonth={'<=$(=Only(UsageYearMonth))>=$(=Only(UsageYearMonth)-2)'>} distinct OrderId)

Bu i dont konw how to add the month yaer ago

because I can only write one set analysis I can't seperate them. The should be presented in one chart.

Thank you