Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

How to get range

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.




Capture.PNG

Thanks

5 Replies
prma7799
Honored Contributor III

Re: How to get range

Try like this

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

+

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

MVP
MVP

Re: How to get range

Could you share your sample app?

Not applicable

Re: How to get range

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

pradosh_thakur
Valued Contributor III

Re: How to get range

try

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


regards

Pradosh

FrankHartmann
Honored Contributor

Re: How to get range

Can you share a sample?

Community Browser