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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Lor1995
Contributor
Contributor

COUNT IF

Dear All,

I'm new to QS and I'm trying to grasp its syntax and scripting features in order to set up a reporting and dashboard view for my company. 

I should set an expression for a KPI box that'd allow me to calculate the distinct number of unique "# ID booking" when/if the associated VAR. NS is >0, in order to analyze how many bookings out of total generate a VAR. Net Sale. 

I tried to sort it out myself but it either doesn't work or it returns me an invalid number.

Hope you can help me out here.

Thanks in advance!

0 Replies