topic Qlikview Conditional Expression on Chart in QlikView

Qlikview Conditional Expression on Chart

Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 05 Jun 2017 10:17:31 GMT

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 — Mon, 05 Jun 2017 10:43:48 GMT

Set Analysis

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