Set Analysis

[#1]

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

[swuehl]

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)

[#4]

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]

Maybe like

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

[#7]

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