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: 
fishing_weights
Creator
Creator

YTD countif there is at least one value (counta)?

The table 

Date ID

31 Aug 2022

a

31 Aug 2022

b

31 Jul 2022

a

31 Jul 2022

b
31 Jul 2022 c
31 Jun 2022 null

 

The request: If  there is an ID for the date to return 1 and sum up all the 1's  from YTD

The required result: because only 2 months in 2022 has values

Year result
2022 2

 

How do i create a ytd tracking as such? thank you

1 Reply
G3S
Creator III
Creator III

in a straight table you can load the year, then  measure: if(not isnull(ID) or ID<>'null', count(distinct(ID))