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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis

2.Hi Folks,

I have a Type Filter (Type1, Type2, Type3)

I want to show 3 kpi's for each type

i write the expression as below given,

Count({<Type={"Type 3 "}>}Ticket)

It was showing count, when i want select the Type2 - Type2 only show the value, others are blank.

1. default also i want to show the value

2. If select a particular Type its should the value based on Type, others should be zero.

How to show others are blank

Regards,

Sub2u444

6 Replies
swuehl
MVP
MVP

Try the intersection operator *

Count({<Type *= {"Type 3 "}>}Ticket)

sunny_talwar

You can also do this:

If(Type = 'Type 3 ', Count({<Type={'Type 3 '}>}Ticket), 0)

or this if you can have more then one selected at a time

If(SubStringCount(Concat(DISTINCT Type, '|'), 'Type 3 ') = 1, Count({<Type={'Type 3 '}>}Ticket), 0)

Not applicable
Author

Hi,

Thanks for the reply, it was working.

Instead of 0, i want to show null/blank value...

sunny_talwar

Can you try this:

If(SubStringCount(Concat(DISTINCT Type, '|'), 'Type 3 ') = 1, Count({<Type={'Type 3 '}>}Ticket))

swuehl
MVP
MVP

Maybe like

If( Count({<Type *= {"Type 3 "}>}Ticket) > 0, Count({<Type *= {"Type 3 "}>}Ticket), '')

Not applicable
Author

@Swuehl,Sunny-Thanks for the reply and thank you so much for your support