Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Calculate with Set Analysis

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

4 Replies
Not applicable

Re: Calculate with Set Analysis

try this

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

Not applicable

Re: Calculate with Set Analysis

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

Not applicable

Re: Calculate with Set Analysis

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...

Not applicable

Re: Calculate with Set Analysis

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

Community Browser