Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating Date Filters with Different Date Fields

Hello all,

I am pretty new to Qlikview and I am trying to create a report. I need to have all different date filters

such as months, quarters and fiscal years.

The problem  is I have different charts with different date range. For example for one chart I need

to have volumes based on sent date and in another chart I need volumes based on the response date.

When I want to create these  time filters I need to create them based on 1 date ( as a surce) but I don't want that applies to all

charts in my tab.

(I have all the dates in one table in my data model).

So if you faced the same issue I appreciate if you let me know.

Thank you,

Behnaz

1 Reply
dakohler
Contributor III
Contributor III

Hi Behnaz

you could create a master calendar with month, quarter, year,... as an island table.

There are many script examples in the community how to create a calender.

In the chart objects you need to work with set analysis expressions.

Example:

Create variables for your date fields (Crtl + Alt + V)

vYear  =Concat(DISTINCT DateIslandYearField,Chr(39)&','&Chr(39))

Chart 1 Expression:

sum( {$<SentDateYear = {'$(vYear)'} >} Volume)

Chart 2 Expression:

sum( {$<ResponseDateYear = {'$(vYear)'} >} Volume)