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

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Set Expression

Hi Experts,

How can i write set expression for below code

=count(DISTINCT if(len(GatePassDate)= 0,if(len([Repair Category])<> 0, BBND_ROs)))

regards

mahesh

Labels (1)
20 Replies
sunny_talwar

Can you share a screenshot with the output of these two expressions

1) =Count({<BBND_ROs={"=len(GatePassDate)= 0 and len([Repair Category])<> 0"}>} distinct BBND_ROs)


2) =count(DISTINCT if(len(GatePassDate)= 0,if(len([Repair Category])<> 0, BBND_ROs)))