topic Re: Drill down group in QlikView

Drill down group

Wed, 25 Nov 2020 16:16:04 GMT

hi all,

Using the Line chart,i am trying to display items sold using the drill down group Month-> Week ->Day-> Hour .

When i drill down and get to the hour, i can see the items sold on particular hour. My requirement is to see the sales on selected hour in middle and sales before on left and after hour in the right in the graph.

Is there a way to do this. Hour is my last level in the drill down group.

Regards

Re: Drill down group

sunny_talwar — Wed, 11 May 2016 01:32:22 GMT

Would you be able to share a sample?

Look at some of these threads which can help you get you quick responses for your question

QlikCommunity Tip: How to get answers to your post?‌

Preparing examples for Upload - Reduction and Data Scrambling‌

Uploading a Sample

Re: Drill down group

Anonymous — Wed, 11 May 2016 01:40:42 GMT

At a high level

* Create 2 additional measures that are only shown when an hour is selected.

* Use set analysis to return data that relates to Hour-1 and Hour+1 for each of these measures.

Re: Drill down group

Wed, 11 May 2016 07:52:15 GMT

Thanks for the reply. i couldn't workout the set analysis to display multiple dimension points.

Please find the sample data and qvw file.

The drill down works from date to hour.

when i click on particular hour, is it possible to display a hour after and before in comparison.

I.E : when i click 10, the graph should show 9,10 and 11 hour detail in the graph.

Thanks

Re: Drill down group

sunny_talwar — Wed, 11 May 2016 10:07:08 GMT

This is partially worrking, you would just need to figure out the best way to make this work when you are checking 12 am for example

Re: Drill down group

Wed, 11 May 2016 11:30:27 GMT

Thanks Sunny.

This works for me. I will change the time to a 24 hour format.

Re: Drill down group

sunny_talwar — Wed, 11 May 2016 13:41:48 GMT

Even after that it might give you issue when the day changes. 24, 0, 1 could be problematic. You can use date + time to handle that scenario I guess.