topic Re: Set Expression in QlikView

Set Expression

upaliwije — Thu, 05 Mar 2015 04:06:37 GMT

Hi Friends

Sum({<Shedule_Name={"Accured_Expenses"}>}BALANCE_BF)

The above expression is not working. Can someone tell me what is wrong in it

Re: Set Expression

MayilVahanan — Thu, 05 Mar 2015 04:15:29 GMT

Your expression looks fine. May be

Is there any space is available in "Accured_Expenses"?

or do u miss any case sensitive ?

Shedule_Name field is in "Capital Letter"?

Can you able to share the screenshot of the application?

Re: Set Expression

PrashantSangle — Thu, 05 Mar 2015 04:15:49 GMT

Hi,

Your expression looks fine for me.

just check you have data for BALANCE_BF where Schedule_Name="Accured_Expenses"

If possible post sample app.

Regards

Re: Set Expression

renjithpl — Thu, 05 Mar 2015 04:18:37 GMT

Use single quotes...

Sum({<Shedule_Name={'Accured_Expenses'}>}BALANCE_BF)

Re: Set Expression

anbu1984 — Thu, 05 Mar 2015 06:33:28 GMT

May be because of mis-spelling?

Sum({<Shedule_Name={"Accrued_Expenses"}>}BALANCE_BF)

Re: Set Expression

tamilarasu — Thu, 05 Mar 2015 07:09:07 GMT

Sum({<SChedule_Name={"Accrued_Expenses"}>}BALANCE_BF)

Re: Set Expression

avinashelite — Thu, 05 Mar 2015 07:11:29 GMT

try with single quotes inside the set analysis

Re: Set Expression

jagan — Thu, 05 Mar 2015 08:42:10 GMT

Hi,

First note that Qlikview is case sensitive and make sure you have given "Accured_Expenses" in correct casing, or copy the value from the list box and paste it in the expression.

Next thing is make sure that you have values for this selection, otherwise it return null value.

If possible attach some sample file, it would be easier to find the issue.

Hope this helps you.

Regards,

Jagan.