topic Re: Month & Date calculation in QlikView

Month & Date calculation

Mon, 15 Sep 2014 21:17:20 GMT

Hi All,

I have to develop below dashboard based on the below conditions.

I have to get total by month.

If there is no selection of Year, Month, Day (Default to Current year, Current month total and so on)
If Year only selected and that is Less than current year, show DEC month & Selected Year.

e.g. 2013 selected, totals should be DEC & 2013, Nov2013,oct 2013, sept2013.

3. If Year only selected and that is Current year default to Current month & current year and so on.

e.g. 2014 selected, show Sept 2014, aug 2014, july 2014, june 2014.

4. If Year, Month selected – show as selected in boxes.

5. If Day only selected, show the current month and current year and so on.

6. If month only selected, show current year and current month and so on.

7. if Quarter selected and no year selected, show that quarter months and current year

8. if year and Quarter selected – show those months.

marcus_sommer — Tue, 16 Sep 2014 00:25:31 GMT

You could read the selections with getfieldselections(), getselectedcount() and so on and use these values for your calculations, for example:

if(getfieldselections(Year) = year(today()), THEN, ELSE)

if(rangesum(getselectedcount(Year), getselectedcount(Month), getselectedcount(Day)) < 1, THEN, ELSE)

But I think 8 different levels are too much, it will be (too) difficult for a user to find out which selection leads to which calculation.

- Marcus

Tue, 16 Sep 2014 12:30:26 GMT

Hi Anyone,

used this before?

Thanks,

Lakshmi