topic Re: Hide File IF in QlikView

Hide File IF

qlikviewaf — Thu, 23 Nov 2017 11:40:32 GMT

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!

Re: Hide File IF

Or — Thu, 23 Nov 2017 11:51:20 GMT

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

Re: Hide File IF

qlikviewaf — Thu, 23 Nov 2017 11:54:48 GMT

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!!

Re: Hide File IF

Or — Thu, 23 Nov 2017 12:02:57 GMT

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.