topic Re: set expression in QlikView

set expression

upaliwije — Sat, 06 Aug 2016 13:47:05 GMT

Hi Friends

I have created a varibale and want to insert the same in an expresiion

My expression is ({<HOUR_GROUP-={NR}>}$(vPerClaim)) but It is not working. Kidly correct If I am wrong

Thanks

Re: set expression

vishsaggi — Sat, 06 Aug 2016 14:09:02 GMT

May be try this:

({<HOUR_GROUP-={'NR'}>}$(vPerClaim))

Re: set expression

upaliwije — Sat, 06 Aug 2016 14:16:53 GMT

Not working.

My Problem is if I wite the expression withot a vraivle it workig

eg: sum({<HOUR_GROUP-={NR}>}amount)

Re: set expression

swuehl — Sat, 06 Aug 2016 14:25:20 GMT

What's the definition of your variable?

You can put your expression including the variable in an expression in a straight table and leave the expression label empty, then hover with the mouse over the expression header of the table chart.

It should show your expresssion with the dollar sign expansions expanded. Check if the result is like expected (i.e. variable replaced to your field name).

Re: set expression

upaliwije — Sat, 06 Aug 2016 14:36:43 GMT

Thanks

my varible is floows

sum(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV-RF_PROV))-SUM({<CLAIM_NO={'MOTOR SALVAGE LOT'}>}SALVAGE)

If I put this varible in thos way $(vPerClaim) it is working. But when I try couple with set modifier

{<HOUR_GROUP-={NR}>} it does not work

Re: set expression

vishsaggi — Sat, 06 Aug 2016 14:44:56 GMT

Try what setfan suggested and let us know if you still face the same. Please send us a sample app that defines the problem.

Re: set expression

upaliwije — Sat, 06 Aug 2016 14:55:35 GMT

I have tried still the same result

Re: set expression

Clever_Anjos — Sat, 06 Aug 2016 15:00:58 GMT

You can´t have a sum inside another sum without an AGGR()

Your variable return a sum() that is inner to a sum()

Usefull reading: Pitfalls of the Aggr function

Re: set expression

upaliwije — Sat, 06 Aug 2016 15:10:45 GMT

Thanks

Can you pls rewtite my Variable to help me

Re: set expression

swuehl — Sat, 06 Aug 2016 15:27:17 GMT

You would need to add the set modifier to a set expression in each aggregation function you want it to apply to:

sum({<HOUR_GROUP-={NR}>} rangesum(CL_PROV,+CL_ADJUS,-RE_PROV-RF_PROV))

-SUM({<CLAIM_NO={'MOTOR SALVAGE LOT'}, HOUR_GROUP-={NR}>}SALVAGE)

Re: set expression

Sun, 07 Aug 2016 02:41:17 GMT

Hi,

May be syntax wrong

u call variable like this

<HOUR_GROUP-={NR}>},$(=vPerClaim))