topic Re: how to write a set analysis in QlikView

how to write a set analysis

kunkumnaveen — Fri, 18 Aug 2017 13:09:14 GMT

Hello ,

how to write this in set analysis DOC_DATE>VALIDFROM and <VALIDTO

i tried this

DOC_DATE={">=$(VALIDFROM )<=$(VALIDTO)"}

Only the DOC_DATE=01-07-2017 is a valid one,i need to show only that AMOUNT

Any suggestion plz

sunny_talwar — Fri, 18 Aug 2017 13:14:44 GMT

Better to use if statement here or create a flag in the script

If(DOC_DATE > PK_VALIDFROM and DOC_DATE < PK_VALIDTO, 1, 0) as Flag

kunkumnaveen — Fri, 18 Aug 2017 13:20:25 GMT

Hello ,thanks for your reply ,

At script level DOC_DATE is coming from different table

and the rest two Fields are coming from different table

i think i need to create to it in set analysis only?

if so

sum(DOC_DATE={">=$(VALIDFROM )<=$(VALIDTO)"}>}Amount)

sunny_talwar — Fri, 18 Aug 2017 13:22:49 GMT

Then I would say, just use this:

Sum(If(DOC_DATE > PK_VALIDFROM and DOC_DATE < PK_VALIDTO, AMOUNT))