topic Re: Expressions in text box query in QlikView

Expressions in text box query

Thu, 20 Aug 2015 10:34:37 GMT

Hi All

I am using a text box to display a GP Code by using the following script:

='GP Code: ' & concat(DISTINCT [Practice Code],', ')

The problem is that this returns all of the possible data entries.

What I'd like it to do is for the text box to be blank unless "Client Number" or "NHS Number" is selected.

I have tried to combine the above with "getcurrentfield" (getselectedcount([NHS Number])>0 or getselectedcount([Client Number])>0 ) but this doesn't work

I'd appreciate any advice on this please

Thank you in advance

Claire

Re: Expressions in text box query

alexandros17 — Thu, 20 Aug 2015 10:36:41 GMT

It is strange it doesn't work, could you send an example doc?

Re: Expressions in text box query

gautik92 — Thu, 20 Aug 2015 10:42:35 GMT

did yu try lik this

Re: Expressions in text box query

Anonymous — Thu, 20 Aug 2015 10:48:10 GMT

Try it as:

=if(getselectedcount([NHS Number])>0,
'Practice: ' & concat(Distinct [GP Practice],', ',),

if(getselectedcount([Client Number] )>0,
'Practice: ' & concat(Distinct [GP Practice],', ',),
'Please select NHS or Client Number'))

...which I think should work.

Re: Expressions in text box query

Anonymous — Thu, 20 Aug 2015 10:53:32 GMT

actually only ='GP Code: ' & concat(DISTINCT [Practice Code],', ') should work

you select 1 GP Code, only 1 code should be shown in TextBox

so it might be some other Settings?

Example from QV WhatsNewin QV11:='test ' &concat(DISTINCT Region,', ')

Re: Expressions in text box query

Thu, 20 Aug 2015 10:55:50 GMT

There are instances where a Patient/Client might be registered with more than 1 GP Practice in a year, so I need to be able to see all options, but only when NHS Number or Client Number is selected....

Re: Expressions in text box query

Thu, 20 Aug 2015 10:58:37 GMT

This works perfectly, thank you!