topic Re: How to get range in QlikView

How to get range

kunkumnaveen — Fri, 06 Oct 2017 05:28:20 GMT

Hello All,

Kindly suggest me what i am missing from the below expression,i am getting output as zero

sum({<BVALIDFROM={"<$(=YearStart(Today(),0,4))"},BVALIDTO={">$(=YearStart(Today(),0,4))"}>}BPrice)

when i tried in two different expressions it is working

Expression1: sum({<BVALIDFROM={"<$(=YearStart(Today(),0,4))"}>}BPrice)

Expression2: sum({<BVALIDTO={">(=YearStart(Today(),0,4))"}>}BPrice)

when i merge both the expression i am getting zero as output.

Thanks

prma7799 — Fri, 06 Oct 2017 05:42:22 GMT

Try like this

sum({<BVALIDFROM={"<$(=YearStart(Today(),0,4))"}>}BPrice)

sum({<BVALIDTO={">(=YearStart(Today(),0,4))"}>}BPrice)

tresB — Fri, 06 Oct 2017 05:48:41 GMT

Could you share your sample app?

Fri, 06 Oct 2017 08:41:09 GMT

Kindly share the dummy data, so that can get back to you with correct set analysis.

pradosh_thakur — Fri, 06 Oct 2017 16:06:25 GMT

try

sum({<BVALIDFROM={"<$(=YearStart(Today(),0,4))"}>} * {<BVALIDTO={">$(=YearStart(Today(),0,4))"}>}BPrice)

regards

Pradosh

Frank_Hartmann — Fri, 06 Oct 2017 16:15:55 GMT

Can you share a sample?