topic Re: Capturing No Selection in QlikView

Capturing No Selection

Wed, 02 Jul 2014 08:56:45 GMT

Hi All

I have a requirement of not populating a particular column if no selection has been made.

I can do it using IF condition on comparison of Count(distinct <Dim>) vs Count(distinct all <dim>) to check if anything has been selected. But this is cumbersome as I have multiple dimensions for selection, is there a better way to do it ?

Re: Capturing No Selection

SunilChauhan — Wed, 02 Jul 2014 09:09:10 GMT

create a variable

let vField=Concat([$Field],',')

count({<$(vField)=>}distinct ID)

hope this helps

Re: Capturing No Selection

stigchel — Wed, 02 Jul 2014 09:17:49 GMT

Not sure if I'm missing something here, but how about a simple GetSelectedCount([$(=Dim)]) ??

Re: Capturing No Selection

Wed, 02 Jul 2014 09:31:51 GMT

Thanks Sunil and Piet.

But what do I compare it against ... as no selection means ALL values are selected.

Had it been None selected, then I could compare the Count with 0 or string against Null.

Re: Capturing No Selection

SunilChauhan — Wed, 02 Jul 2014 09:41:32 GMT

i dont know what you want.but i have suggest to exlude all fields selection in perticular chart.

suggest if any other?

Re: Capturing No Selection

stigchel — Wed, 02 Jul 2014 09:46:31 GMT

I'm definitely missing something, no selection only equals ALL values selected when this field has a value for each row.

What user interaction scenario are you thinking off? You may need to include a sample qvw for us to understand what you mean.

Re: Re: Capturing No Selection

Wed, 02 Jul 2014 12:39:03 GMT

Please refer to the attached report.

If you look at the data, Share is applicable and constant to a particular combination of Product & Area.

So the requirement is, the share column should be blank if

1. No selection done

2. Multiple selections in Product AND/OR Area

The share column should populate only if 1 Product & 1 Area is selected.

Hope this helps in understanding the requirement.

Re: Capturing No Selection

stigchel — Wed, 02 Jul 2014 13:24:33 GMT

For the share expression mark the conditional expression and put:

GetSelectedCount(Product)=1 and GetSelectedCount(Area)=1