Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis

Hi All, nedd help, i have a table :

AbonementIDAbonementEndDate
12013.03.03
22013.03.04
32013.03.06
42013.02.04
52013.02.05
62013.04.06
72013.02.07
82013.03.08
92013.03.09
102013.04.10
112013.04.11
122013.06.12

i need 2 set analysis, one: i need count all active abonements at the start of month, for examp: at 1 of march i have 9 active abonements,

second set analysis: i need count all active adonements at the month  end(march 31), expecting result =3

please help

14 Replies
Not applicable
Author

thanks again, and one more question , ok, if i select on master calendar year and month its show me correct values, but if is no selected in the calendar its show me a wrong values..why? i need . when i activating sheet, it show me all tendency by year and month of abonements..now my set analysis is:

COUNT({<Abonement.End = {">=$(=MonthStart(Max(Date)))"}>}distinct SabID)

and

COUNT({<Abonement.End = {">=$(=MonthEnd(Max(Date)))"}>}distinct SabID)

MK_QSL
MVP
MVP

If you will not select anything, you will get result

for 1st Expression This Month TO DATE data...

for 2nd Expression ,,, will give you null or o

Not applicable
Author

so how can i modified set analysis to avoid this problem?

MK_QSL
MVP
MVP

This depends on what outcome you want?

I still unclear about your requirements !

Not applicable
Author

now its calculate only if i select year and month in master calendar, and calculate id only in one month, i want without any selection in master calendar calculale id in each available month