topic Re: set analysis for data display? in QlikView

set analysis for data display?

Anonymous — Fri, 26 Sep 2014 10:45:34 GMT

i have a month list box

month:

[

jan

feb

mar

oct

nov

dec

];

i made a bar chart with dimension as month and expressions as sum(sales).

my req is i dont want see the sales for current month and previous month.

for example we are IN SEP so i dont want see sales for month of sep,aug(current month and previous month)

if we moved to OCT then i dont want see sales for month of OCT and SEP ?

senpradip007 — Fri, 26 Sep 2014 10:49:48 GMT

Try like:

Sum({<Month={"<$(=Max(Month)-1)"}>} sales)

Anonymous — Fri, 26 Sep 2014 10:52:28 GMT

it will ignore last month only what about current month pradip..

Anonymous — Fri, 26 Sep 2014 10:59:09 GMT

you want to see up to current month

Sum({<Month={"<$(=Month(today()))"}sales)

if you want to see only current and previous month

sum({<Month={">=$(=month(today()-1)<=$(=month(today()))"}sales)

senpradip007 — Fri, 26 Sep 2014 10:59:57 GMT

Did you try with that expression?

Anonymous — Fri, 26 Sep 2014 11:03:09 GMT

no yar ,not yet

ok i will try tell u

Anonymous — Fri, 26 Sep 2014 11:03:49 GMT

i want exclude current month and previous month ,rest of the month i want to see

Anonymous — Fri, 26 Sep 2014 11:10:38 GMT

then

sum({<Month={"<$(=month(today()-1))">}sales)

should work