topic Re: Currently Selected field in QlikView

Currently Selected field

Tue, 31 May 2011 07:30:12 GMT

Hi Guys,

Thanks for ur support in this forum.

Please help to find out this trick.

I need to get currently selected field to use in a chart. Mns I have a field named 'Project Type'

It has three values like 'Maintenance', 'Development', 'Consultancy'.

I want to show text box when the value of [Project Type] is 'Maintenance'

Thanks in advance.

Currently Selected field

Tue, 31 May 2011 07:48:32 GMT

In Text Box -> Layout -> Show (Conditional -> [Project Type] = 'Maintenance').

When ever you select the Maintenance this text box would be displayed in your chart.

Re: Currently Selected field

Anonymous — Tue, 31 May 2011 07:50:55 GMT

Hey,

Take a look at the GetFieldSelections() function.

From F1 help:

getfieldselections( FieldName [, ValueSep [, MaxValues]] )

Returns a string with the current selections in a field.

ValueSep is the separator to be put between field values. The default is ', '.

Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.

Examples

getfieldselections ( Year )

getfieldselections ( Year, '; ' )

getfieldselections ( Year, '; ' , 10 )

(EDIT: Ah, I seem to have misunderstood the question. Thought you wanted to show the current selection that you had made, in a text object)

Currently Selected field

pat_agen — Tue, 31 May 2011 07:53:26 GMT

hi,

use the function getfieldselections().

This will show what you have selected in the field [Project Type].

So if I understood your request you want to display a text box when [Project Type] is "Maintenance".

Create your text box, on the Layout tab make "Show" conditional with the following expression:

if(getfieldselections([Project Type])='Maintenance',1,0)

Currently Selected field

Tue, 31 May 2011 08:05:27 GMT

Hi pat,

Thanks for ur reply.

I tried in ur way. But still I m not getting the result as I needed.

I m using QV 10 SR2. Is thr any pblm with tat?

Please clarify this.

Thanks

Currently Selected field

pat_agen — Tue, 31 May 2011 08:20:02 GMT

hi,

don't know about the version issue and can't test it but I'd be very surprised.

Start by creating a text box without the "show" condition expression.

in the tex box put the expression:

=getfieldselections([Project Type]).

now start selecting on your [Projetc Type] field. What happens to the text box? This should display the selected value of [project Type] when one and only one value has been selected. Is this the case? If not there is a typo.

The idea is to test the result of the above expression against the string 'Maintenance' and show the textbox if this condition is met.

try again - I tested it her and it works (v8.5).

by the way Sivasubramanian's solution woul ddo the job too.

good luck.

Currently Selected field

Tue, 31 May 2011 08:45:27 GMT

Hi pat,

Again I ve tried it as u said.

It works perfectly in the text but not in the show condition expression.

I dono y happening like this... But before I ve tried with other chart types. I didn't face any pblm like this.

I ll try to find out wats the pblm in this n ll post u.

thanks.