topic Re: SET expression How to add one more condition ? in QlikView

SET expression How to add one more condition ?

paulyeo11 — Wed, 31 Jan 2018 01:53:20 GMT

Hi All

Below expression working fine :-

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000)

I need to add one more condition to above expression , that is SOURCE = TDSS , So my expression as below :-

Sum({$<year = {$(=Max(year)-1)},SOURCE = {"TDSS"}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000)

But it display null. may i know where i go wrong ?

Paul

kenphamvn — Wed, 31 Jan 2018 02:14:42 GMT

The expression is fine

Please check column name SOURCE is correct? and "TDSS" exist

you can test by using only new condition

Sum({$< SOURCE  ={"TDSS"}>} sales/1000)

Regards

An Pham

paulyeo11 — Wed, 31 Jan 2018 02:33:43 GMT

Hi Pham

Your propose expression work fine , but when i add one more condition :-

Sum({$< SOURCE ={"TDSS"}>,year ={"2018"}>} sales/1000)

it does not work. Where i go wrong ?

Paul

kenphamvn — Wed, 31 Jan 2018 02:56:09 GMT

Try this

Sum({$< SOURCE  ={"TDSS"} ,year  ={"2018"}>} sales/1000)

Remove ">"

Sum({$< SOURCE ={"TDSS"}>,year ={"2018"}>} sales/1000)

Regards

An Pham

paulyeo11 — Wed, 31 Jan 2018 04:09:43 GMT

hI pHAM

Thank you very much for your help. Now work fine.

Paul