Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Howto: Limit/filter data dimension in a Bar chart?

I would like to limit dimension in bar chart (that represent dates) - to show only data representing last month available (from data load date).- is that possible? - I have a field called LoadDate in the dataset with the loaded date represented as YYYY-MM-DD.Capture.PNG

1 Solution

Accepted Solutions
vinay_hg
Contributor II

Re: Howto: Limit/filter data dimension in a Bar chart?

you have to write conditional dimension in dimension i.e.

=if(date(Date,'dd/mm/yyyy')>date(LoadDate,'dd/mm/yyyy'),Date)

it will work!!!..

4 Replies
vinay_hg
Contributor II

Re: Howto: Limit/filter data dimension in a Bar chart?

you have to write conditional dimension in dimension i.e.

=if(date(Date,'dd/mm/yyyy')>date(LoadDate,'dd/mm/yyyy'),Date)

it will work!!!..

Not applicable

Re: Howto: Limit/filter data dimension in a Bar chart?

Don't forget to untick "Show null values"

you could also do this with Set Analysis

Not applicable

Re: Howto: Limit/filter data dimension in a Bar chart?

Yep it did work :-) thanks !! - now I just have to figure out how to limit on a number of days backward from data loaddate rather than an actual date.... (So i always have last ie. 20 days displayed)

vinay_hg
Contributor II

Re: Howto: Limit/filter data dimension in a Bar chart?

try this

here i consider LoadDate as your dimension.

=if(date(LoadDate,'dd/mm/yyyy')>date(Today(),'dd/mm/yyyy')-20,LoadDate)


or

if u want backdate of field LoadDate and by considering your Date field is Dimension

=if(date(Date,'dd/mm/yyyy')>date(LoadDate,'dd/mm/yyyy')-20,Date)