Creating Date Filters with Different Date Fields

Fri, 02 Aug 2013 23:25:14 GMT

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

Re: Creating Date Filters with Different Date Fields

Anonymous — Sun, 04 Aug 2013 21:14:36 GMT

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)