topic Text Variable to Set Analysis in QlikView

Text Variable to Set Analysis

Mon, 18 Oct 2010 18:29:55 GMT

Dear All,

I´m trying to pass a variable (vAccountSet) with 3 text members to my chart. But I can´t get it work. Can you help me? I want to get something like this:

Account	Amount	Driver	AmountD	Ratio
Energy	1370	Employee	134	10.22
Water	2104	Employee	134	15.70
Gas	2131	Employee	134	15.90

Text Variable to Set Analysis

Mon, 18 Oct 2010 19:46:06 GMT

I would take the logic out of the dimension and instead put it into the expressions as Set Analysis. Set the dimension to Account and then in your expressions use some Set Analysis to limit the accounts. For the first expression:

Sum({<Account = {$(=Replace(vAccountSet, ' or ', ','))}>} Amount)

This is a little more complicated, because you separated your accounts with or in the variable. If you change those to commas, you can probably just use Account = {$(=vAccountSet)}.

You may need to modify some of the other expressions to make them Aggregate functions. Only would work for some. I couldn't come up with the proper expression for the ratio. I'm not exactly sure how that one works. I've attached an example.

Text Variable to Set Analysis

Tue, 19 Oct 2010 15:35:35 GMT

Thanks for your help. The logic is in the dimmension because I need dynamic charts. I attached the solution.