Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Please correct my expression

Count({$<[Pump ID]=P({1<[%Link Pump Group]={"*$(=count(DISTINCT [%Link Pump Group])-count(DISTINCT{<[DYN Group Param Id]=p([DYN Group Param Id])>}[%Link Pump Group]))*"}>}[Pump ID])>}[Pump ID])

As I want to get the count of PUMP ID

based on the values coming from

(=count(DISTINCT [%Link Pump Group])-count(DISTINCT{<[DYN Group Param Id]=p([DYN Group Param Id])>}[%Link Pump Group])

this expression returns 76 but when I placed this espression then it is not wotking . actually this 76 is my count but I want 76 values coming in my SQL script.

Is this right or please correct me.

0 Replies