topic Re: Calculate with Set Analysis in QlikView

Calculate with Set Analysis

Tue, 09 Jul 2013 09:33:02 GMT

Hi evereybody

I have a calculated dimension like this: if(Account_Group = 'WHVIGREV','Gross Revenue', ..., Null())

This dimension works perfectly!

I created a bar chart with the calculated dimension and as an expression a Set Analysis like this: Sum( {$ < Version={ACT}, Account_Group= > } EUR*-1)

It works too!

But now I´d like to create a bar chart where I can calculate with Set Analysis like this: Sum( {$ < Version={ACT}, Account_Group= > } EUR*-1) / Sum( {$ < Version={ACT}, Account_Group= {WHVIGREV} > } EUR*-1)*100

In this case WHVIGREV is Gross Revenue and I want to show the percentage of every position in the calculated dimension of WHVIGREV (Gross Revenue).

Could anybody help me?

Regards

Steven

Re: Calculate with Set Analysis

Tue, 09 Jul 2013 09:38:04 GMT

try this

(Sum( {$ < Version={'ACT'}, Account_Group= > } EUR*-1) / Sum( {$ < Version={'ACT'}, Account_Group= {'WHVIGREV'} > } EUR*-1) ) *100

Re: Calculate with Set Analysis

Tue, 09 Jul 2013 09:41:56 GMT

try this,

in first expression-Sum( {$ < Version={'ACT'}, Account_Group= > } EUR*-1)

in second expression- Sum( {$ < Version={'ACT'}, Account_Group= {'WHVIGREV'} > } EUR*-1)

in third expression-- (column(1) / column(2)) *100

Re: Calculate with Set Analysis

Tue, 09 Jul 2013 09:45:36 GMT

Thanks for your really fast help

If I understand it right, it is not possible to calculate with two Set Analysis / to combine two Set Analysis in ONE expression?

Now I try your proposal...

Re: Calculate with Set Analysis

Wed, 10 Jul 2013 08:30:56 GMT

I hope that there is a better solution instead of having 3 expressions for 1 calculation...