topic Date issue in qlikview in QlikView

Date issue in qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 ??

Re: Date issue in qlikview

rahulpawarb — Thu, 01 Feb 2018 06:12:41 GMT

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

Re: Date issue in qlikview

Anonymous — Thu, 01 Feb 2018 06:26:13 GMT

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

Re: Date issue in qlikview

karthikoffi27se — Thu, 01 Feb 2018 07:00:06 GMT

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

Re: Date issue in qlikview

rahulpawarb — Thu, 01 Feb 2018 07:09:30 GMT

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