Qlikview Conditional Expression on Chart

[#1]

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!

[PrashantSangle]

Hi,

Try with set analysis in front end.

In script you can implement similar logic which you are trying in sql.

Regards,

Prashant Sangle

[avinashelite · Accepted solution]

Set Analysis

Sum({<Field_Name={'20170601'}>}Value)-Sum({<Field_Name={'20170501'}>}Value)-