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: 
siva_boggarapu
Creator II
Creator II

technical issue(if data matches need to exclude) -help me

I  Have a field called   Courseid={a,b,c,d,e,f,g,h}  normally   when i count this i will get count =8.

but  when ever courseid matches with  {a} i have to exclude   b, c,d  courses .  so when ever i count  courseid {a}  then no need to count {b},{c},{d}.


that means   i have to count  only {a,e,f,g,h }


so finally  my courseid count =5 has to come  , please  help me


this calculation implemented in  chart level  not in script level

Regards'

Siva

10 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi Siva,

It is possible, create an excel file with the following columns

Course      Course Group


and fill the values in this and load it into the dashboard.


Regards,

Jagan.