Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
s_santalucia
Partner - Creator
Partner - Creator

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
Somasundaram
Creator III
Creator III

HI,

 

In master calendar, you can create a field AsOfDate.

Use this field for filtering. 


-Somasundaram
Anil_Babu_Samineni

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)
s_santalucia
Partner - Creator
Partner - Creator
Author

Hi, this way not work because not filter.
sunny_talwar

What you might need is this

The As Of Table

 

Anil_Babu_Samineni

@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)