Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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
Luminary Alumni
Luminary Alumni

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.