topic Re: Getfieldselections Function for multiple items in QlikView

Getfieldselections Function for multiple items

Thu, 06 Oct 2011 12:01:40 GMT

Good Day

I have a model where the user will select a period (month & year) and one of my objects needs to calculate the Actual YTD up to and including the selected period. For this, I am explicitly stating in my object's expression that the current selections must be ignored but that the Actual amount must be calculated up to and including the selected period ... sum( {1} if ( [Fiscal Period] <= getfieldselections([Fiscal Period]) , Actual) ..

My problem is that I also need to allow the user to select different expense categories such as Fuel, Wages etc. But, because I'm using {1} in my expression, my object isn't dynamically updating through Expense Category selections made. I've tried using the getfieldselections function in my expression for Expense Categories but it only works for one selected item. How can I get this to work for multiple selected items and when no Expense Category is selected?

Please help, I need assistance urgently

Thanks,

Shane

Getfieldselections Function for multiple items

lironbaram — Thu, 06 Oct 2011 12:09:38 GMT

hei

insted of using {1} in your set analysis

why cant you use somthing like {<month=,year=>}

Re: Getfieldselections Function for multiple items

Thu, 06 Oct 2011 12:47:32 GMT

Hi Liron,

I have tried your suggestion but it returns a blank result. I'm not sure if I have the syntax correct:

sum({<[Financial Category Description] = {'Expenses'}, [Fiscal Period] = {"<=$ (=vCurrentMonthNum)"}>}Actual)

Thanks

Re: Getfieldselections Function for multiple items

lironbaram — Thu, 06 Oct 2011 12:52:18 GMT

sum({<[Financial Category Description] = {'Expenses'}, [Fiscal Period] = {"<=$ (#vCurrentMonthNum)"},year=,month=>}Actual)

or can you post sample data

Re: Getfieldselections Function for multiple items

Thu, 06 Oct 2011 12:52:36 GMT

Hi,

Try is with double quots around Expenses.

Succes, Halmar

Re: Getfieldselections Function for multiple items

Thu, 06 Oct 2011 14:52:02 GMT

Hi, I've created a sample document that simplifies what I'm doing. What I need is the line graph to show up to the selected period but the line graph must also be affected by selections made on the Account Category. I really appreciate the responses guys. Thanks, SJ

Re: Getfieldselections Function for multiple items

lironbaram — Thu, 06 Oct 2011 15:09:02 GMT

hei

attach is an example

the logic in the expression is to calculate year to date

it show all values from maximum date to year statr for the maximum date

Re: Getfieldselections Function for multiple items

Mon, 10 Oct 2011 09:37:06 GMT

Thanks so much Liron. Your solution is just what I'm aiming for.