Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Effective use of date field and Calendar in a QV application

Hi,

I am working on the application where I need to populate the datasheet on screen according to selected year/years and month/months or by specific date. I have multiple columns on that datasheet which contains date field. I am sharing the screen shot of it.

QV_1.PNG

The year and Month field should get populated with the distinct year and month which contains last 8 columns. And on selecting particular year/years and month it should only populate the records which contains the selected year and month.

After after clicking "By Date" field, it will hide the year and month tab, and it will show calendar selection option as follows:

QV_2.PNG

It should automatically populate the From date as the minimum date from all of those eight columns and in To Calendar it shouldn't allow us select the date less than From date.

How to achieve this?

0 Replies