Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to write set expression?

How to write setexpression below conditons

if(guid>=1,count(distinct((guid)))/if(Serialno >=1,count(distinct(Serialno))

Thnks,

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Something like this:

Count({<guid={">=1"}>} Distinct guid) / Count({<Serialno={">=1"}>} Distinct Serialno)

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

its not giving the output

it giving zero value

Anonymous
Not applicable
Author

can u provide us a sample Qvw