Hide File IF

[qlikviewaf]

Hi,

I have a field called "Sales Rep" - i would like to hide some calculation in case there's any selection on the field "Sales Rep"

How this can be done?

Thank you for the support!

[Or]

You can use Conditional Display coupled with GetSelectedCount([Sales Rep])>0, assuming you want to hide the entire column.

[qlikviewaf]

Well, i'm thinking that maybe is better to switch this on customer field.

My condition is: if NO selection has been done on Customer.

So if 5 customer have been selected -> not caluclate

If 1 Customer have been selected -> not calculate

If there's no selection on Customer Field - > Calculate

How i can reach this?

Thanks!!

[Or]

Again, the question is what you mean when you say "calculate".

You can hide dimensions, expressions, or objects using conditional display. You can use the GetSelectedCount() function to see if a selection has been made or not (>0 means a selection has been made on that field, 1 means exactly one value has been selected).

If you want to modify calculations rather than hide columns/objects entirely, you can do that as well - you'll have to work the If(GetSelectedCount()>0) aspect into your formulas as appropriate.

Keep in mind that your description is inconsistent with your examples - if five customers have been selected, a selection HAS been done on Customer.