topic Re: GETFIELDSELECTIONS in QlikView

GETFIELDSELECTIONS

Mon, 11 Feb 2013 16:44:58 GMT

Hello everyone!

I have an field like this:

='Chosen Customer: ' &GetFieldSelections(DimCustomer.CustomerID)

Which returns me an customer

Now i wanna throw this customer down in a variable - I do this by making an action and making an set variable

HOWEVER

It is only shown in my variable when i click on my ='Chosen Customer: ' &GetFieldSelections(DimRaptorCustomer.CustomerID)

Can i make it dynamic so i wont have to click on it? otherwise it wont filter my data automaticcaly when selection a customer

Re: GETFIELDSELECTIONS

Mon, 11 Feb 2013 19:42:25 GMT

Can u maybe take a look at my sample??

Cause if i use a variable

='Chosen Customer: ' &vSelectedframecustomer

and vSelectedframecustomer is =getfieldselections(DimCustomer.CustomerID)

Then sometimes when i select and deselect and select it wont show the value again.

Would you take a look??

Re: GETFIELDSELECTIONS

Mon, 11 Feb 2013 19:58:21 GMT

The strange thing is that it works sometimes.

If i make a plain textbox with variable

and then a listbox with customerid

It its always right.

But when i use it in my textboxes, its only the half of the times.

Re: GETFIELDSELECTIONS

Thu, 18 Apr 2013 13:14:56 GMT

Hi,

Try the below code in UI.

If( IsNull( GetCurrentSelections()) ,0, GetPossibleCount(DimCustomer.CustomerID))

If you do selection in any field and the Data got filtered in CustomerID as well even though you didn't selected the CustomerID , By using this Expression you can get the Current Selected count of Customer ID .

//Yusuf

Re: GETFIELDSELECTIONS

Wed, 27 Nov 2013 12:02:14 GMT

I also have a question related to getfieldselections() :

I use this function in a chart expression: the user selects the months from a listbox and the expression sums the sales by taking only the months in the table that are equal to the selections.

Anyway, I noticed that when selecting more than 6 months the current selections box shows "NOT Aug,Sept,...". Because of this result I can't get the selections.

Anyone has an idea on how to resolve this?

Thanks,

Cristina

Re: GETFIELDSELECTIONS

Wed, 27 Nov 2013 12:07:17 GMT

i cant remember this-. but it cannot show more than 6 values. But i think there is a fix to it - but i cannot remember how

Re: GETFIELDSELECTIONS

Wed, 27 Nov 2013 12:09:21 GMT

use this instead:

se this getfieldselections(fieldname,',',8) instead of 8 u can specify how many filednames u want to display.....

Re: GETFIELDSELECTIONS

Wed, 27 Nov 2013 12:29:48 GMT

Thank you!

It worked.