Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

date field in filter pane

Hi all,

 

i want to create a yeartodate filter .

ex. when i select this filter box, the dashord is filtered on the dates from the beginning of the yaer to max selected date, without insert set analysis in measure.

 

 

thanks!

Labels (1)
5 Replies
Highlighted
Creator III
Creator III

Re: date field in filter pane

HI,

 

In master calendar, you can create a field AsOfDate.

Use this field for filtering. 


-Somasundaram
Highlighted

Re: date field in filter pane

Perhaps this? Make sure, You have to use Date format if any wrong in the condition.

If(DateField>=YearStart(Max(TOTAL DateField)) and DateField<=Max(TOTAL DateField), DateField)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

Re: date field in filter pane

Hi, this way not work because not filter.
Highlighted

Re: date field in filter pane

What you might need is this

The As Of Table

 

Highlighted

Re: date field in filter pane

@s_santalucia If this is not filter, Why title required as filter? I am happy, IF you can explain little more like What you want to build after filter happen and Where you want to get as field like Filter box or Script field etc.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)