7 Replies Latest reply: Oct 21, 2015 6:18 AM by SAI Somarowthu

# QS does not support set analysis Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

Hi All

I have a expression below :-

Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

it work fine , when i do it in Qlik View. But when i using the same expression , i get wrong result.

Can some one share with me , what are the alternative expression can work in QS.

Basically i use above expression with diamension YearMonth it will plot for me monthly revenue amount.

Paul

• ###### Re: QS does not support set analysis Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

It will Work

Sum({<rEVENUE={'rEVENUE'}>}Amount)/1000

use single quotes

Regards

Ram

• ###### Re: QS does not support set analysis Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

Make sure your document contains a field called rEVENUE and that the field contains a value "rEVENUE". Qlik Sense is case sensitive. REVENUE, revenue, Revenue and rEVENUE are four different values.

• ###### Re: QS does not support set analysis Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

Hi Gysbert

Yes my QS have this field.

And Since the expression is work fine in QV , and when i paste the same expression into QS , and it show the different value , meaning QS does not support the expression.

another other alternative expression i can replace ?

Paul

• ###### Re: QS does not support set analysis Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000
And Since the expression is work fine in QV , and when i paste the same expression into QS , and it show the different value , meaning QS does not support the expression.

Or it means that your Qlik Sense app contains different information. Or it means you made a typo somewhere. Or ... one of half a dozen other possible causes. Can you post your qlikview document and the qlik sense app?

• ###### Re: QS does not support set analysis Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

create it as a measure

and add that measure to chart

it will work

• ###### Re: QS does not support set analysis Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

Hi All

It was my mistake that last night I am too tired and never reload QVD well , end up the set analysis does not work for my QS.

Today it happen on QV , then I did reload again and now working fine.

Thank you for all your help.

Paul

Sent from my iPhone

• ###### Re: QS does not support set analysis Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

in this way we can use set analysis in qlik sense