qlik sense set analysis

[mistnh001]

ตัวอย่าง count( distinct If( Year= [PAT_INFO.YFirstDate] ,[PAT_INFO.HN])) 

สามารถทำให้เป็นรูปแบบ set analysis ได้หรือไม่ครับ 

[jyothish8807 · Accepted solution]

Hi Mistnh,

Try this:

Count({<[PAT_INFO.HN]={"=Year=[PAT_INFO.YFirstDate]"}>}[PAT_INFO.HN])

or

Count({<Year={"=Year=[PAT_INFO.YFirstDate]"}>}[PAT_INFO.HN])

or 

count(if(Year=[PAT_INFO.YFirstDate],[PAT_INFO.HN]))

You can also try creating a flag in your table if both Year and [PAT_INFO.YFirstDate] is in same table

In script:

Load *,

if(Year=[PAT_INFO.YFirstDate],1,0)  as Flag

from <>;

Then in front end: Count({<Flag={1}>}[PAT_INFO.HN])

[mistnh001]

thank you very muck