topic Conditional Show on Text Box with 2 GetSelectedCount Fields in QlikView

Conditional Show on Text Box with 2 GetSelectedCount Fields

stjernvd — Thu, 17 Dec 2015 14:59:02 GMT

Hi,

In my text box 'text' section I've put this:

=If(GetSelectedCount(Metrics)=0 and GetSelectedCount(Dimension)=0,'Please Select a Dimension and Metric',(if(GetSelectedCount(Metrics)>0,'Please Select a Dimension', 'Please Select a Metric')))

and in the layout part I've put so that the text box only appears when:

=GetSelectedCount(Dimension)=0 and GetSelectedCount(Metrics)=0

These are the conditions for the different text to show in my text box:

1. When GetSelectedCount(Metrics and Dimension) = 0, 'Please Select a Dimension and Metric'

2. When GetSelectedCount(Metrics)>0 and GetSelectedCount(Dimension) =0, 'Please Select a Dimension'

3. When GetSelectedCount(Dimension)>0 and GetSelectedCount(Metrics) =0, 'Please Select a Metric'.

How do I formulate the correct formula in my text expression and layout tab so my text box shows the above texts accordingly?

Re: Conditional Show on Text Box with 2 GetSelectedCount Fields

sunny_talwar — Thu, 17 Dec 2015 15:06:23 GMT

May be this as the text box expression:

=If(GetSelectedCount(Metrics) = 0 and GetSelectedCount(Dimension) = 0, 'Please Select a Dimension and Metric', If(GetSelectedCount(Metrics) > 0 and GetSelectedCount(Dimension) = 0, 'Please Select a Dimension',

If(GetSelectedCount(Metrics) = 0 and GetSelectedCount(Dimension) > 0, 'Please Select a Metric')))

and this on the layout tab:

GetSelectedCount(Metrics) = 0 or GetSelectedCount(Dimension) = 0

Re: Conditional Show on Text Box with 2 GetSelectedCount Fields

stjernvd — Thu, 17 Dec 2015 15:13:44 GMT

it worked thank you so much!

Re: Conditional Show on Text Box with 2 GetSelectedCount Fields

sunny_talwar — Thu, 17 Dec 2015 15:15:33 GMT

Awesome