topic Issue with set analysis expression in QlikView

Issue with set analysis expression

Wed, 16 Dec 2015 21:25:33 GMT

Hi,

Can anyone please let me know what's the error in this expression:

=sum({<[Report Date]={'>=$(vToDateMonthStart) <=$(vToDateMTD)'}>} [New Issuance])

vToDateMonthStart and vToDateMTD are variables.

vToDateMonthStart returns 11/1/2015

And vToDateMTD returns 11/28/2015

Regards,

Sachin

Re: Issue with set analysis expression

sunny_talwar — Wed, 16 Dec 2015 21:29:02 GMT

Have you tried with Double quotes instead of single quotes?

=Sum({<[Report Date]={">=$(vToDateMonthStart) <=$(vToDateMTD)"}>} [New Issuance])

or try this

=Sum({<[Report Date]={"$(='>=' & $(vToDateMonthStart) & '<=' & $(vToDateMTD)"}>} [New Issuance])

Re: Issue with set analysis expression

Wed, 16 Dec 2015 21:30:57 GMT

Hey Sunny,

Thank you.

=sum({<[Report Date]={'>=$(vToDateMonthStart) <=$(vToDateMTD)'}>} [New Issuance]) ---- worked

Re: Issue with set analysis expression

sunny_talwar — Wed, 16 Dec 2015 21:34:13 GMT

‌So your original expression worked?

Re: Issue with set analysis expression

Wed, 16 Dec 2015 21:36:11 GMT

Yeah, I didn't understand what went wrong initially. I have been breaking my head since past 2 hrs and then it just worked.

Anyways thanks for the prompt and quick reply, Sir.

Re: Issue with set analysis expression

sunny_talwar — Wed, 16 Dec 2015 21:39:27 GMT

Hahahaha no problem . I would recommend marking your own answer as correct (as technically yours is the correct answer) as it might help some one else in the future.

Best,

Sunny