topic Re: Keepchat in expression ! in QlikView

Keepchat in expression !

Mon, 16 Jul 2012 17:53:54 GMT

Hi All,

I have a expression and with an error that I can't fix it:

=sum( {$<YEAR = {$(=MAX(YEAR))},PERIOD={KeepChar( Vcurrent,'2')}>} DOLLAR )

Could anybody tell me what's the problem with the keepchar part?

Thanks,

Nima

MayilVahanan — Mon, 16 Jul 2012 18:07:42 GMT

Hi,

Before use a variable in expression itself, use keepchar function.. and use like this,

= Sum ({<Year = { $(=Max(Year))} ,Period ={'=$(=vCurrent))'}>} DOLLAR)

vCurrent = > KeepChar(Year,'2') something like this

Hope it helps

Mon, 16 Jul 2012 18:14:21 GMT

That's the problem!

I have to use keepchar in expression because the Vcurrent changes based on the selection.

I want to re-use the Vcurrent for different columns, like :

PERIOD={KeepChar( Vcurrent,'3')} or

PERIOD={KeepChar( Vcurrent,'4')} and so on.

Any help is appreciated.

Thanks,

Nima

Mon, 16 Jul 2012 18:32:24 GMT

Sorry the Doc is big and upload it

MayilVahanan — Mon, 16 Jul 2012 18:41:52 GMT

HI,

Try like this,

=sum( {$<YEAR = {$(=MAX(YEAR))},

Period= {'=$(=KeepChar(Vcurrent,chr(39) &2 & chr(39)))'}>}Dollar)

Hope it helps

Mon, 16 Jul 2012 19:13:18 GMT

Thanks, but it returns nothing in expression but it text box it's good.

kind of weird !!

MayilVahanan — Mon, 16 Jul 2012 19:20:50 GMT

Hi,

Check in expression step by step.. You can find the solution..

=sum( {$<YEAR = {$(=MAX(YEAR))} >}Dollar)

=sum( {$<Period= {'=$(=KeepChar(Vcurrent,chr(39) &2 & chr(39)))'}>}Dollar)

Then combine both..You can find solution.

Hope it helps