topic Re: Date Variable in QlikView

Date Variable

upaliwije — Sat, 02 Sep 2017 05:46:49 GMT

Hi,

I have created a date variable in QV app

vP16={'>={15-AUG-2016} <={01-SEP-2016'}

How ever this return 0 vale when applied in following expression

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE=$(vP16)>}Nos)

Pls advise where I have made the mistake

Re: Date Variable

Kushal_Chawda — Sat, 02 Sep 2017 05:54:58 GMT

why don't you directly write in set analysis instead of creating variable

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE={'>=15-AUG-2016 <=01-SEP-2016'}>}Nos)

vP16='>=15-AUG-2016 <=01-SEP-2016'

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE={'$(vP16)'}>}Nos)

Re: Date Variable

upaliwije — Sat, 02 Sep 2017 06:04:59 GMT

Thanks Kushal

In fact I have several expression in doc so it is easy for me to use a variable. However your expression works but not when the expression with variable is applied. I feel something wrong with the definition of variable. Pls advise.

Re: Date Variable

Kushal_Chawda — Sat, 02 Sep 2017 06:11:31 GMT

vP16='>=15-AUG-2016 <=01-SEP-2016'

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE={$(vP16)}>}Nos)

there will be error but it will work

Re: Date Variable

upaliwije — Sat, 02 Sep 2017 08:20:39 GMT

Thanks a lot

Re: Date Variable

arasaraja_cts — Sat, 02 Sep 2017 13:59:17 GMT

Hi,

PFA, hope it will help.

Thanks

Raja.