topic Re: QS does not support set analysis Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000 in App Development

QS does not support set analysis Sum({}Amount)/1000

paulyeo11 — Wed, 21 Oct 2015 04:09:07 GMT

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({}Amount)/1000

Anonymous — Wed, 21 Oct 2015 04:55:03 GMT

It will Work

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

use single quotes

Regards

Ram

Re: QS does not support set analysis Sum({}Amount)/1000

Gysbert_Wassenaar — Wed, 21 Oct 2015 05:24:24 GMT

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({}Amount)/1000

paulyeo11 — Wed, 21 Oct 2015 05:29:35 GMT

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({}Amount)/1000

Gysbert_Wassenaar — Wed, 21 Oct 2015 05:32:28 GMT

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({}Amount)/1000

Anonymous — Wed, 21 Oct 2015 05:40:33 GMT

create it as a measure

and add that measure to chart

it will work

Re: QS does not support set analysis Sum({}Amount)/1000

Anonymous — Wed, 21 Oct 2015 10:18:23 GMT

in this way we can use set analysis in qlik sense

Re: QS does not support set analysis Sum({}Amount)/1000

paulyeo11 — Wed, 21 Oct 2015 10:24:27 GMT

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