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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

2 Variables in set analisys

hi,

i need to count feild with 2 Variables, in expression.

count date when type=regular & billets is greater then 3.

i wrote like this, but i get nothing :

count(DISTINCT{<type='regular''},sum(DISTINCT([billets)>={4})>}start date

how i need to write it ?

thanks'

yarin.

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi Yarin,

Did you try this yet =Count({$<type = {'regular'}, billets = {">3"}>} DISTINCT [start date])

Regards,

Sokkorn

View solution in original post

1 Reply
Sokkorn
Master
Master

Hi Yarin,

Did you try this yet =Count({$<type = {'regular'}, billets = {">3"}>} DISTINCT [start date])

Regards,

Sokkorn