topic Using GetFieldSelections in an expression in QlikView

Using GetFieldSelections in an expression

Mon, 13 Feb 2012 11:41:29 GMT

Hi,

Hopefully a quick question.

I have a master calendar and an assoicated table full of sales values. What I want is two columns in a straight table, the first showing the values from the selected year from a listbox populated from the master calendar. The second column needs to show the values from the previous year.

I have left the first column's expression as =Sum([DAILYSALES-SALES-VALUE-EXTAX])

The second column's expression as =Sum({$<CALENDARYEAR=GetFieldSelections(CALENDARYEAR)-1> [DAILYSALES-SALES-VALUE-EXTAX])

The editor says there is a syntax error, but I dont't know how to fix it.

Can someone point me in the right direction with regards to using GetFieldSelections within an expression, or alternatively is there another/better way to get year on year comparison within a straight table, where the user either selects a single year from a list box, or has to select two years?

Thanks

Trevor

Using GetFieldSelections in an expression

CELAMBARASAN — Mon, 13 Feb 2012 11:45:31 GMT

Hi,

Use Expression as

=Sum({$<CALENDARYEAR={$(=Max(CALENDARYEAR)-1)}> [DAILYSALES-SALES-VALUE-EXTAX])

Celambarasan

Using GetFieldSelections in an expression

lironbaram — Mon, 13 Feb 2012 11:47:29 GMT

you need to change to

Sum({$<CALENDARYEAR={"$(=GetFieldSelections(CALENDARYEAR)-1)"}> [DAILYSALES-SALES-VALUE-EXTAX])

Using GetFieldSelections in an expression

Mon, 13 Feb 2012 11:59:40 GMT

Hi Syntax now shows as ok, but I don't get any data returned at all

Using GetFieldSelections in an expression

Mon, 13 Feb 2012 12:01:00 GMT

Hi, as per other post, syntax shows ok, but still no data being returned. The syntax looks very strange to me? What is the purpose of all the double quotes ? I can't find anything about this in the reference guide.

Using GetFieldSelections in an expression

CELAMBARASAN — Mon, 13 Feb 2012 12:05:18 GMT

Hi,

Check with this expression

=Sum({$<CALENDARYEAR={'$(=Max(CALENDARYEAR)-1)'}> [DAILYSALES-SALES-VALUE-EXTAX])

Celambarasan

Using GetFieldSelections in an expression

jagan — Mon, 13 Feb 2012 12:20:53 GMT

Hi,

Try this expression

=Sum({$<CALENDARYEAR={'=$(=Max(CALENDARYEAR)-1)'}> [DAILYSALES-SALES-VALUE-EXTAX])

Hope this helps you.

Regards,

Jagan.