topic set analysis- help on expression in QlikView

set analysis- help on expression

Tue, 20 May 2014 16:28:21 GMT

HI all,

pls do me a favor .

my requirement is to calculate ytd ...where the expression should contain selected year and all months including current selection. example month selected is march then it shud display data for jan, feb and march along with selected year...!

kindly help on this with the expression !!

any help on this will be much appreciated

Re: set analysis- help on expression

rogerioqv — Tue, 20 May 2014 16:36:54 GMT

Try this sintax:

SUM({1<YEAR = {YEAR}, MONTH = {"<=$(#=ONLY(MONTH))"}>}SALES

Re: set analysis- help on expression

Tue, 20 May 2014 16:41:54 GMT

Thanks buddy ....cud u pls tell wat does 1 signify in syntax..?? )

Re: set analysis- help on expression

rogerioqv — Tue, 20 May 2014 16:44:37 GMT

The number 1 ignores the of selections made.