topic Re: Help with expression in QlikView

Help with expression

vijetas42 — Wed, 04 Apr 2018 12:32:11 GMT

Hi All,

I am having data like below,

where my requirement is i need only those key and name where fee has been changed over month.

expected output is,

1-aa

2282018

Please help with the expression.

olivierrobin — Wed, 04 Apr 2018 12:41:18 GMT

hello

you can use an expression like

date(monthyear,'DMMYYYY')>Reference Date (you may need to use date() function arond you reference date)

vijetas42 — Wed, 04 Apr 2018 12:44:41 GMT

i don't want to calculate reference date.

olivierrobin — Wed, 04 Apr 2018 12:45:36 GMT

is you reference date the beginning of the month ?

tresB — Wed, 04 Apr 2018 12:49:51 GMT

May be like:

where fee<>Peek(fee); // to avoid the first row you might use 'and recno()>1' as additional clause

vijetas42 — Wed, 04 Apr 2018 13:00:29 GMT

for now i have added expression to fee like,

IF(fee<> Above(TOTAL fee),sum(fee)) so it's showing whole table with value for changed key but, also showing other key with null values.

it's giving output like,

but i want only second row where value is there

tresB — Thu, 05 Apr 2018 05:11:34 GMT

PFA

vijetas42 — Thu, 05 Apr 2018 06:38:55 GMT

Thanks Tresesco!

It worked but i have one doubt that in rangemax(sum(fee),0.0000001) what does 0.0000001 indicates? because when I used only 0 it's not working.

tresB — Thu, 05 Apr 2018 06:50:37 GMT

That's to avoid 'zero suppression'. You have to be sure if you could afford to have small fraction in the chart calculation.

vijetas42 — Thu, 05 Apr 2018 07:11:37 GMT

Thanks for all your help