topic Re: set analysis in QlikView

set analysis

Tue, 09 Dec 2014 06:47:40 GMT

HI,

in my dashboard year and month listboxes are there.

when i clicked any year and month then appear sales of that year,above all months of that selected month

EX:

i selected 2014,march output is sales of mar,apr,may........dec in 2014

i selected 2013,march output is sales of mar,apr,may........dec in 2013

sushil353 — Tue, 09 Dec 2014 06:53:53 GMT

Hi,

Try like:

Sum({<Year= {'$(=Max(Year))'},Month = {">= $(=Max(Month))"}>}Sales)

HTH

Sushil

kiranmanoharrode — Tue, 09 Dec 2014 06:56:50 GMT

Hi Anil,

Try Below Expression:

=Sum({<DateField={"$(>=Max(DateField))"},YearField=,MonthField=>}Sales)

Regards,
Kiran

jagan — Tue, 09 Dec 2014 06:57:40 GMT

Hi,

Try like this, If you have a date field

sum({<MonthDimension=, DateDimensionName={'>=$(Date(Max(DateDimensionName)))<=$(=YearEnd(Max(DateDimensionName)))'}>}Sales)

Hope this helps you.

Regards,

Jagan.