Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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?

Tags (2)
1 Solution

Accepted Solutions
sushil353
Honored Contributor II

Re: Filter Dimension in Chart

Hi,

I think below code should work:

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

also check the option for suppress null values.

HTH

Sushil

2 Replies
Not applicable

Re: Filter Dimension in Chart

Hi,

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

Thanks

piyush

sushil353
Honored Contributor II

Re: Filter Dimension in Chart

Hi,

I think below code should work:

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

also check the option for suppress null values.

HTH

Sushil

Community Browser