topic Re: need help in QlikView

need help

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

I have tickets raising daily to particular group with opendate time , Now the user is asking me to show the no of incidents raised for the particular date and hour(drill down/cyclic) , how can i show? i want to show in calender object also how?

below is the sample data

Load *inline

[

Group, NO, Opendate, Closed date

abc,12,12-02-2016-5pm,12-02-2016 7pm

abcq,122,12-02-2016-6pm,13-02-2016 pm

abcq,121,12-02-2016-7pm,13-02-2016 7pm

abca,124,12-02-2016-8pm,13-02-2016 7pm

abcs,123,12-02-2016-9pm,13-02-20161pm

abce,1321,12-02-2016-10pm,13-02-2016 4pm

abc3,132,12-02-2016-11pm,13-02-2016 7pm

abc4,112,12-02-2016-12pm,13-02-201647pm

ab4c,1222,12-02-2016-2pm,13-02-2016 3pm

ab5c,1122,12-02-2016-3pm,13-02-2016 7pm

ab3c,1232,12-02-2016-1pm,13-02-2016 7pm

ab2c,1432,12-02-2016-2pm,13-02-2016 7pm

ab6c,1452,12-02-2016-4pm,13-02-2016 7pm

];

Re: need help

MK_QSL — Wed, 08 Mar 2017 11:27:50 GMT

Canonical Date

Re: need help

mshailaja — Wed, 08 Mar 2017 11:38:23 GMT

I want to show the incidents opened date and time in drill down/cyclic , in chart , how to do?

Re: need help

Anil_Babu_Samineni — Wed, 08 Mar 2017 15:12:36 GMT

May be use Cyclic with the dimensions are [opened date] and SubField([opened date],'-', -1) and then use metric like Sum(Measure)

Re: need help

rahulpawarb — Thu, 09 Mar 2017 06:51:34 GMT

Hello Sailaja,

Trust that you are doing well!

Considering given requirement, I have drafted below script (please review and modify it, if required):

Data:

LOAD *,

Date(Date#(Left(Opendate, 10),'DD-MM-YYYY')) AS Date,

SubField(Opendate, '-', 4) AS Time

;

LOAD * INLINE

[

Group, NO, Opendate, Closed date

abc,12,12-02-2016-5pm,12-02-2016 7pm

abcq,122,12-02-2016-6pm,13-02-2016 pm

abcq,121,12-02-2016-7pm,13-02-2016 7pm

abca,124,12-02-2016-8pm,13-02-2016 7pm

abcs,123,12-02-2016-9pm,13-02-20161pm

abce,1321,12-02-2016-10pm,13-02-2016 4pm

abc3,132,12-02-2016-11pm,13-02-2016 7pm

abc4,112,12-02-2016-12pm,13-02-201647pm

ab4c,1222,12-02-2016-2pm,13-02-2016 3pm

ab5c,1122,12-02-2016-3pm,13-02-2016 7pm

ab3c,1232,12-02-2016-1pm,13-02-2016 7pm

ab2c,1432,12-02-2016-2pm,13-02-2016 7pm

ab6c,1452,12-02-2016-4am,13-02-2016 7pm

];

Also refer the attached sample application.

Hope this will be helpful.

Regards!

Rahul