how can I obtain Month by Month the first and end month value ?

[suzel404]

Hi all,

How can I obtain the number of store_id  by month (startMonth and endmonth)

example :

Month       startMonth         EndMonth

1                   XXXX                    xxxx

2                     XXXX                    XXXX

...

12                   XXXX                   XXXX

Thank you for your help.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[suzel404]

Thank you Gysbert!

[robert_mika]

Hi Gysbert.

My (wrong) logic was like this

=COUNT({<CALENDAR_SITE_DTM="$(=DATE(MAX(CALENDAR_SITE_DTM),'DD/MM/YYYY'))"}>}DISTINCT(PUDO_ID))

Would you mind to tell why this does not work?

I assumed that the =DATE(... will return the MAX day and the whole expression the correct number

[Gysbert_Wassenaar]

The set of a set analysis expression is calculated at the chart level, not at row level. Your expression will create a set with only the maximum possible date. You'd see a result only for the last month.

[robert_mika]

SO in your formula the agrr function is taking the formula to row level?

Why did you use FirstSortedValue?

Thank you for your time.

[Gysbert_Wassenaar]

See these tutorials:

http://qlikshare.com/392/

http://qlikshare.com/398/