Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

show only in straight table

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??

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Highlighted
Not applicable

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

Highlighted
Contributor II
Contributor II

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

Highlighted
Not applicable

Ahh i think i misterunderstood your question! sorry..

Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Contributor II
Contributor II

Hoi Gijsbert,

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

Highlighted
Contributor II
Contributor II

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