topic Re: Two calendars in QlikView

Two calendars

krishnakv83 — Thu, 10 May 2018 06:36:42 GMT

Team,

I have a two dashboard which was build on single datamodel

both dashboard will pull last 10 days data for front end. Now front end D1 dashboard got new requirements to show last 2 years data.Challenge is other dashboard D2 should not be disturbed.

Is it possible to develop separate calendars to show 10 days and 2 years data from single datamodel

Regards,

KRishna

Re: Two calendars

tomasz_tru — Thu, 10 May 2018 07:57:21 GMT

As long as you have 2 years history it is possible.

Where's data filter - flag on calendar, condition on application load or conditions in set analysis?

Tomasz

Re: Two calendars

krishnakv83 — Thu, 10 May 2018 08:29:07 GMT

I removed 10days filter and changed the condition to pull two years data.Now 2 years data is coming to dashboard. Now I want to show last 10 calendar dates and data in one tab and 2 years dates ,data in second tab of dashboard.

How to apply a filter in dashboard.Date is field name which is used to pull data.

Re: Two calendars

tomasz_tru — Thu, 10 May 2018 08:40:19 GMT

You can use set analysis - there are plenty examples here. Or introduce flags in the calendar.

Tomasz

Re: Two calendars

krishnakv83 — Wed, 16 May 2018 10:49:48 GMT

Thank you for the mail

Can you give sample formula to show last ten days in the Dates lsit box.

I want to give option to select last 10 days data to users.

Regards,

Venkat

Re: Two calendars

big_dreams — Wed, 16 May 2018 10:57:06 GMT

try below

if(dateField > date(max(dateField)-10),dateField)

Regards,