Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It will Work
Sum({<rEVENUE={'rEVENUE'}>}Amount)/1000
use single quotes
Regards
Ram
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.
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
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?
create it as a measure
and add that measure to chart
it will work
in this way we can use set analysis in qlik sense
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