Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

try this

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

Not applicable
Author

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
Author

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
Author

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