topic Re: Set Analysis in QlikView

Set Analysis

Wed, 30 Mar 2016 13:49:06 GMT

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 — Wed, 30 Mar 2016 13:52:02 GMT

Try the intersection operator *

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

sunny_talwar — Wed, 30 Mar 2016 13:56:39 GMT

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)

Wed, 30 Mar 2016 14:32:53 GMT

Hi,

Thanks for the reply, it was working.

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

sunny_talwar — Wed, 30 Mar 2016 14:35:41 GMT

Can you try this:

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

swuehl — Wed, 30 Mar 2016 14:35:47 GMT

Maybe like

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

Thu, 31 Mar 2016 02:00:55 GMT

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