topic Re: Simple set analysis with less than in QlikView

Simple set analysis with less than

yipchunyu — Wed, 12 Dec 2018 01:16:09 GMT

Just want to prepare an expression to sum up the value for 2018 Jan-Nov.

There are some fields with the data

Trans_Date_M = 1,2,3,4,5,6 ....

Trans_Date_MM = 01,02,03,04 ....

Tried several ways but not ok.

sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M={'<= 12'}>} Amount)

sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M={*} - {12}>} Amount)

Any help?

Re: Simple set analysis with less than

shreya_nadkarni — Wed, 12 Dec 2018 01:59:09 GMT

Hi,

You could try this

sum({<Trans_Date_YYYY={'2018'},Trans_Date_M ={"<=$(=12)"}>} Amount)

Thanks,

Shreya

Re: Simple set analysis with less than

jonathandienst — Wed, 12 Dec 2018 05:27:48 GMT

That would include December. Try this:
sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M={"<12"}>} Amount)

Re: Simple set analysis with less than

yipchunyu — Wed, 12 Dec 2018 07:08:50 GMT

Sorry, tried but not work for me.
Total
sum(USD)
Jan -Nov
sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M={"<=$(=12)"}>} USD)
Dec
sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M={"=$(=12)"}>} USD)

All shows the same no when I select 2018.
Any idea?

Re: Simple set analysis with less than

punitpopli — Wed, 12 Dec 2018 07:26:37 GMT

Can you try this :

=sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M-={"12"}>}Value)

Re: Simple set analysis with less than

yipchunyu — Thu, 20 Dec 2018 07:17:58 GMT

Seems incorrect in syntax check.