Capturing No Selection

[#1]

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 ?

[SunilChauhan]

create a variable

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

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

hope this helps

[stigchel]

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

[#4]

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. 

[SunilChauhan]

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

suggest if any other?

[stigchel]

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.

[#7]

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.

[stigchel]

For the share expression mark the conditional expression and put:

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