topic Re: Conditional Display of Text Box? in QlikView

Conditional Display of Text Box?

Fri, 20 Jun 2014 14:52:19 GMT

Hi folks -

I have a text box that I would like to display if a certain combination of Fields are selected - essentially a warning saying that with the current selections, there is no data to display. I've made an image to use for this purpose and so right now it's just a text box with the image as a background.

How to I make this text box show up conditionally, and disappear if the conditions aren't met (if the user hits back and/or clears selections)?

Thanks!

Re: Conditional Display of Text Box?

ThornOfCrowns — Fri, 20 Jun 2014 14:55:16 GMT

Doesn't the chart automatically give you the "No Data To Display" error message?

Re: Conditional Display of Text Box?

Anonymous — Fri, 20 Jun 2014 14:57:10 GMT

in layout tab, select conditional and use an expression, something like below. this example has almost all possible combinations of field values so modify to your needs.

the text box will show only if all the values are selected for the fields you specify, otherwise, it won't.

=if(GetFieldSelections(State)='(TX|MI)' and GetFieldSelections([FIPS County])='(12012|10000)' and GetFieldSelections(Region)='("Central North"|East)',1,0)

if you need just the field combinations, i would use the following expression in the conditional show:

getselectedcount(/*FieldName1*/)>0 and getselectedcount(/*FieldName2*/)>0

Re: Conditional Display of Text Box?

alexandros17 — Fri, 20 Jun 2014 14:58:06 GMT

In the text object go in the "layout" tab, then in the "show" section select "conditional" and write:

=GetSelectedCount(myField) > 0

with this instruction you display the text box only if there is at least a selection in the specified field. (if you have more than one field to test add conditions with and

e.g: =GetSelectedCount(myField1) > 0 and GetSelectedCount(myField2) > 0

Re: Conditional Display of Text Box?

Anonymous — Fri, 20 Jun 2014 15:00:06 GMT

Hi,

Try something like this:

In the Text box properties ,Under Layout Tab:

For show option, Select conditional and write and expression similar to this:

=if(GetFieldSelections(Field1)= 'P' and getFieldSelections(Field2) = 'A',1,0)

Re: Conditional Display of Text Box?

ashfaq_haseeb — Fri, 20 Jun 2014 15:00:58 GMT

Hi,

Look at the below post.

http://www.quickintelligence.co.uk/qlikview-buttons/

Regards

ASHFAQ

Re: Conditional Display of Text Box?

Fri, 20 Jun 2014 15:02:37 GMT

Well, yes, if there we actually no data to display. The problem for us is that there's a point in which our two datasets cease to match up and we have to let the user know that. We've opted to say that there is no data to display.