topic Re: Expression in QlikView

Expression

Fri, 04 Apr 2014 13:11:07 GMT

Hi all,

I got this table showing me the Km's per truck per week. Now I would like it to show me only the trucks that haven't had any kilometers per week. If I now would say pick week 1 it will show me the trucks that have had kilometers that week. And when I select 10 weeks it will also show me the trucks in week 1 that had 0 kilometers.

expression:
sum(Distance)

kind regards,

Vincent

Re: Expression

alexandros17 — Fri, 04 Apr 2014 13:14:43 GMT

change your expression in:

If(sum(Distance)=0, 'Zero KM', 0)

with this expression when you have zero you set Zero Km, all others will have 0 and if you have kept default settings the checkbox exclude zero values will be cheched

hope it helps

Re: Expression

Fri, 04 Apr 2014 13:22:02 GMT

Hi alessandro,

This indeed gives me the trucks that had 0km's but it isnt really a pretty lay-out. And is it possible to count the number of zero km's trucks?

Re: Expression

santharubban — Fri, 04 Apr 2014 13:23:01 GMT

Try this

=sum({<Distance = {0}>}Distance) in expression

=aggr(sum({<Distance = {0}>}Distance),fleetnumber,year) in diminsion

Re: Expression

Fri, 04 Apr 2014 13:25:18 GMT

Hi Vincent

as far as i can see in your exl sheet some trucks have 0 in week 1

so to see only these trucks but along all weeks you can play with background colors

if (sum(distance)>0, white())

so you'll get white/white color nothing to see, but 0

best regards

chris

Re: Expression

Fri, 04 Apr 2014 13:37:18 GMT

Hi try this...i hope this will help u...

Re: Expression

Fri, 04 Apr 2014 13:38:45 GMT

Re: Expression

alexandros17 — Fri, 04 Apr 2014 13:44:02 GMT

could you send me your document?

Re: Expression

Fri, 04 Apr 2014 13:51:22 GMT

if I upload it here it would be without data i guess?

Re: Expression

alexandros17 — Fri, 04 Apr 2014 13:53:56 GMT

Use scramble instruction ...

Re: Expression

Fri, 04 Apr 2014 14:11:24 GMT

😃

Re: Expression

alexandros17 — Fri, 04 Apr 2014 14:18:32 GMT

Use advanced editor when you reply and attach a file