topic Re: show only in straight table in QlikView

show only in straight table

anitamanders — Tue, 25 Jun 2013 13:19:48 GMT

I have a straight table with

produktcode, min.stock, current stock

I have a formula in produktcode

if(Dimensionality()=3,
if(sum({<factuurdatum={"<$(VarVandaag))>=$(=VarVorigjaar)"}>}aantgelev)<=0, Red(140), Green(200)))

that turns codes with no sales for a year red and others green.

VarVandaag = today

VarVorigjaar =same day last year

aantgelev =sales in boxes

factuurdatum = sales date

My question: is it possible to show only the codes with no sales (so the red codes with this formula) in the straight table??

Tue, 25 Jun 2013 13:23:35 GMT

Remove the last if and under expression select color option, and mark it red

anitamanders — Tue, 25 Jun 2013 13:53:27 GMT

I am sorry thomas, i cannot find the color option.

what do you mean?

my current formula is in the background color option in dimensions

I have added my file

Tue, 25 Jun 2013 14:00:23 GMT

Ahh i think i misterunderstood your question! sorry..

Gysbert_Wassenaar — Tue, 25 Jun 2013 14:12:32 GMT

See the chart on the right in the attached example. Is that what you need?

anitamanders — Tue, 25 Jun 2013 14:16:25 GMT

Hoi Gijsbert,

dat is inderdaad wat ik bedoel, wat heb je precies gedaan?

anitamanders — Tue, 25 Jun 2013 14:19:46 GMT

ik zie het al....soms is de oplossing zo simpel...!!