Date issue in qlikview

[Anonymous]

Hi guys

I have a SQL database table that have data created date 2016,2017,and 2018 that put tgt

i not sure how we separate the data out accordingly to the year in qlikviw ??

[rahulpawarb]

Hello Chen,

Could you please elaborate more on this requirement? If possible paint the current situation with the help of sample data (Current Data & Expected output).

As first level, you can extract the data using loop for every year by passing year as a parameter.

Regards!

Rahul Pawar

[Anonymous]

This is my SQL data,it has  have a field called created,with the date format YYYY-MM-DD HH:MM

It have different years

My expected output is for example when i click on the year button 2016,

the data that are on the range 1/1/2016 and 30/12/2016 will shows on the cart

[karthikoffi27se]

Hi Chen,

Create a master calendar and then when you make the selection it will automatically filter the value for respective years

Please refer to this post for generating master calendar.

Creating A Master Calendar

Many Thanks

Karthik

[rahulpawarb]

Hello Chen,

Thank you for providing details.

First create year field in the script while loading data into application (e.g. Year(Created) as Year)

Then Add an action Select in Field for Year field for every text object.

Thank you!

Rahul Pawar