topic Re: Curent month vs previous in QlikView

Curent month vs previous

Mon, 17 Mar 2014 08:46:49 GMT

Hi All,

need help with set analysis. I have a yearmonth field - StatusHistory.YearMonth

i need to count sabid for curent month and previous month..

for curent month i count :COUNT (distinct SabID)

its works

for previous month i count: COUNT({<StatusHistory.YearMonth = {"$(=StatusHistory.YearMonth(Max(StatusHistory.YearMonth), -1))"}>}distinct SabID)

but is not working

Re: Curent month vs previous

alexandros17 — Mon, 17 Mar 2014 08:49:37 GMT

Try this

COUNT({<StatusHistory.YearMonth = {"$(=Max(StatusHistory.YearMonth), -1)"}>}distinct SabID)

Re: Curent month vs previous

manojkulkarni — Mon, 17 Mar 2014 09:01:23 GMT

Better create a date using monthyear data available, then you can easily add a flag for current & previous month, year etc.

Re: Curent month vs previous

Mon, 17 Mar 2014 09:06:50 GMT

not working..

Re: Curent month vs previous

alexandros17 — Mon, 17 Mar 2014 09:10:48 GMT

Could you provide your example?

Re: Curent month vs previous

senpradip007 — Mon, 17 Mar 2014 09:23:16 GMT

Hi,

In your Master Calendar if there is no year & month then create these two,

Load

MakeDate(Left(StatusHistory.YearMonth, 4), Right(StatusHistory.YearMonth,3)) AS Date,

Left(StatusHistory.YearMonth, 4) AS Year,

Num(Right(StatusHistory.YearMonth,3)) As Month

......

Then try this expression:

Count({<Year = {'$(=Max(Year))'}, Month={'$(=Max(Month))'}>} Distinct SabID) ---- Current Month

Count({<Year = {'$(=Max(Year))'}, Month={'$(=Max(Month) - 1)'}>} Distinct SabID) ---- Previous Month

Hope it helps.

Re: Curent month vs previous

Mon, 17 Mar 2014 10:09:00 GMT

thanks all for replayes, i cant sent a example becouse its very huge (500mb), ist complicate to explain, but i have a master caledar, but i can use ir for his expresion, becouse its coresponds for abonement sales date..i need count all active abonemens for each month, and for this i have field StatusHistory.YearMonth. Waht exacly i need:

i need on straight table have 2 expresions, one - active abonements on month start(i already have it with - COUNT (distinct SabID), second - active abonement on month end (for this i want to get values from next month, , becouse the values of next monthstart active abonemets ant curentmonthend is similar.