Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am new in Qlik Sense, can you please help me out this expression what's I am doing mistake ?
sum of unit sold=sum({[Unit Sold]},Sales Data)
Hi Meera,
In script editior,
please be noted that the variable name always start with letter "v".
can you pls try this below expression
let vrevenue= 'Sum(Sales)*Sum(Stock)' // its working perfectly for me
if it not matching your answer then try separate variable in data load editor or front end variable overview
let vsales= 'sum(Sales)';
let vstock= 'Sum(Stock)';
Let vrevenue= 'a*b';
i hope it will work
Regards,
Durga
Hi,
Set analysis mainly consist of set identifiers, set modifiers and set operators. if you want to understand the set analysis briefly means kindly visit the below link,
https://community.qlik.com/t5/QlikView-Documents/Set-Analysis-syntaxes-examples/ta-p/1491810
and you need a sum of unit sold then
=sum({$}[Unit Sold])
here why you need an sales data or whether you filter out by Sales data
Regards,
Durga
Hi Durgadevikumar
Thanks for your response I have sales data I want to calculate Revenue from two field one is unit sold and another price per unit.....
and I am doing this like
=Sum([Unit Sod])*Sum([Price per Unit])
and wants to assign variable like Let Revenue=Sum([Unit Sod])*Sum([Price per Unit])
but first issue that I am facing is - not able to find data load editor to use Let Command and second my answer is showing wrong while calculating Revenue like the above expression.
Hi Meera,
In script editior,
please be noted that the variable name always start with letter "v".
can you pls try this below expression
let vrevenue= 'Sum(Sales)*Sum(Stock)' // its working perfectly for me
if it not matching your answer then try separate variable in data load editor or front end variable overview
let vsales= 'sum(Sales)';
let vstock= 'Sum(Stock)';
Let vrevenue= 'a*b';
i hope it will work
Regards,
Durga