Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm new to Qlikview and I got a problem.
I have a dataset which contains two days records like 20170601 and 20170501.
And I want to use one column record of 20170601 to minus another column record of 20170501.
But I don't know how to choose this conditional data records in qlikview.
I can do this easily in R or sql use 'where' function.
But how can I do this in Qlikview?
Both on chart expression or script editor are OK.
Many thanks!
Set Analysis
Sum({<Field_Name={'20170601'}>}Value)-Sum({<Field_Name={'20170501'}>}Value)-
Hi,
Try with set analysis in front end.
In script you can implement similar logic which you are trying in sql.
Regards,
Prashant Sangle
Set Analysis
Sum({<Field_Name={'20170601'}>}Value)-Sum({<Field_Name={'20170501'}>}Value)-