topic Re: Amount to display in QlikView

Amount to display

master_student — Fri, 28 Oct 2016 10:26:10 GMT

Hello community,

I would like to set a condition

if sum(poktndd) >0 and IS NOT NULL(LB) => sum(poktndd)

else don't display the amount / sum(poktndd)

Any idea please?

Thanks

Re: Amount to display

sunny_talwar — Fri, 28 Oct 2016 10:34:04 GMT

So like this?

If(Len(Trim(LB) > 0 and Sum(poktndd) > 0, Sum(poktndd))

Re: Amount to display

master_student — Fri, 28 Oct 2016 10:44:42 GMT

there are errors in your expression

Re: Amount to display

sunny_talwar — Fri, 28 Oct 2016 10:46:49 GMT

Yes my bad, I forgot a parenthesis within my first condition:

If(Len(Trim(LB)) > 0 and Sum(poktndd) > 0, Sum(poktndd))

Re: Amount to display

master_student — Fri, 28 Oct 2016 10:53:21 GMT

Re: Amount to display

sunny_talwar — Fri, 28 Oct 2016 10:56:11 GMT

Is your field name all Upper case? May be this:

If(Len(Trim(LB)) > 0 and Sum(POKTND) > 0, Sum(POKTND))

These are things we won't know so you have to make sure that you take care of them at your end

Re: Amount to display

master_student — Fri, 28 Oct 2016 10:59:53 GMT

Thanks for your help sunny. The fields names are correct.

Re: Amount to display

sunny_talwar — Fri, 28 Oct 2016 11:01:06 GMT

So did it work or not?

Re: Amount to display

master_student — Fri, 28 Oct 2016 11:06:12 GMT

Re: Amount to display

sunny_talwar — Fri, 28 Oct 2016 11:08:36 GMT

Have you tried clicking ok to see if you see any result or not? Where are you using this condition? Would be able to share screenshots of your LB and POKTND/poktnd field? To make both our life easier, would you be able to share a sample?

Re: Amount to display

master_student — Fri, 28 Oct 2016 11:18:53 GMT

Sorry

now the expression is correct

but here's the result :

I want that those records to disappear with '-'

Re: Amount to display

sunny_talwar — Fri, 28 Oct 2016 11:22:09 GMT

If LB is your dimension, why don't you select 'Suppress When Value Is Null' on the dimension tab to remove all those records where LB is null?

Re: Amount to display

master_student — Fri, 28 Oct 2016 11:34:19 GMT

I don't want to suppress whene LB is null, because there are LB nulls and the amount POKYNDD is not null, I want this line to appear

Re: Amount to display

sunny_talwar — Fri, 28 Oct 2016 11:39:06 GMT

It seems you have more than one expression in your chart. You might need to use this logic for all your expressions.

If(Len(Trim(LB)) > 0 and Sum(poktndd) > 0, OtherExpressions)