Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter Dimension in Chart

Seems a simple one but can't seem to find the answer. I have an order chart with all the order weeks running along the X axis but I only want to show those from the current week going forward. I already have the current week stored in another field.

Thought I'd try put something like [orderweek]>=[currentweek] in the dimension field but that didn't work. Can someone help?

1 Solution

Accepted Solutions
sushil353
Master II
Master II

Hi,

I think below code should work:

if(orderdate>currentweek,order,null())

also check the option for suppress null values.

HTH

Sushil

View solution in original post

2 Replies
Not applicable
Author

Hi,

can you transfer that current week into variable and compare value like [orderweek]>=[Variable name].

Thanks

piyush

sushil353
Master II
Master II

Hi,

I think below code should work:

if(orderdate>currentweek,order,null())

also check the option for suppress null values.

HTH

Sushil