topic Re: Suggest solution for multiple dates value in QlikView

Suggest solution for multiple dates value

Wed, 29 Jan 2014 09:27:27 GMT

Hi All,

can anyone suggest me how to showcase different date field based value in one single chart based on year/month/week/quarter??

Show case item count -Issued date

Show case item count -Activationdate

Show case item count -Expireddate

---------------------------------------------------------------------------- em viewing this w.r.t year-month-quarter-week

waiting for valuable solution.

Regards,

Prajna

Re: Suggest solution for multiple dates value

whiteline — Wed, 29 Jan 2014 09:44:22 GMT

Hi.

It seems that your data model is instance/object based, so you have different facts connected to different dates.

The task that you mentioned above assumes 'event' based model, where there is only one time(date) field and each case/action has type (Issued/Activated/Expired) and common date.

So you can calculate the number of events that have happened on each date.

There is also 'state' based model, where you have the state of each item on each date (assuming that each event connected with item and changes its state).

In this case you can calculate the number of items that have corresponding state on each date.

Re: Suggest solution for multiple dates value

Wed, 29 Jan 2014 09:49:26 GMT

Hi,

can u tell me how to implement this 'event' based model ?

Regards,

Prajna

Re: Suggest solution for multiple dates value

sujeetsingh — Wed, 29 Jan 2014 09:59:34 GMT

Alva ,

It can be that you are going to create a cyclic group with year>quarter>month>week

for each dates and then use them as dimension .

Re: Suggest solution for multiple dates value

Wed, 29 Jan 2014 10:03:03 GMT

the problem is em not able to write expression to get count w.r.t different dates

can u help me with the syntax?

as the common date is derived from load using resident table as shown in previous post.

I want 3 separate view in a single chart.

Regards,

Prajna

Re: Suggest solution for multiple dates value

whiteline — Wed, 29 Jan 2014 13:35:02 GMT

Load all your data into a floating table containing at least two fields: date, datetype.