topic Drilling Features in QlikView

Drilling Features

Thu, 11 Nov 2010 08:11:15 GMT

Hi,

I have some data in excel sheet which contains the date in yyyy-mmm format. I want to apply drill up / drill down from year to month. How to do that. I am using the trial version as of now

Drilling Features

Thu, 11 Nov 2010 08:21:12 GMT

Hi Advayaa,

You have not mentioned how many years and how many months data available in each year.Well by using following command you need to make two columns such as Year,Month

Ex:

Year(Date_Field) as Year,

Month(Date_Field) as Month

Now you will get two column.And select chart which you want to show.And click "Edit Groups" under "Dimension" tab.Now

you can select both Year and Month column as dimension.Write your measure in "Expression" tab.

For any calrification let me know.

Thanks & Regards

Jai

Drilling Features

Fri, 12 Nov 2010 06:07:23 GMT

Hi, my data contains the data for 4 years and all the months in these four years ie a total of 48 months. n there are mutiple data for each month also . eg of date field is 2007-jan, 2007-feb, 2010-jun.

Drilling Features

Fri, 12 Nov 2010 06:09:02 GMT

Drilling Features

Fri, 12 Nov 2010 07:28:43 GMT

Hi,

You can proceed the step which I mentioned earlier.You will get the result.

Thanks & Regards

Jai

Drilling Features

Fri, 12 Nov 2010 09:36:55 GMT

Date_Baggage	No_Of_Baggage_Arriving_Ontime	No_Of_Baggage_Mishandled	Total_No_Of_Baggage	Reason_Code
2007-JAN	2700000	6000		DT01
2007-JAN		10000		DL02

this is the sample of the data i have , I am creating a bar chart that shows the date_baggage in the x-axis and the sum(No_Of_Baggage_Mishandled ) in the y-axis . In this report i want the data to be drilled up and down . so please tell me the exact steps . \

And where to write these queries

Ex:

Year(Date_Field) as Year,

Month(Date_Field) as Month

Drilling Features

Mon, 15 Nov 2010 07:31:35 GMT

Hi,

here with I have attached a sample file.Find the attachmnet.For further query let me know the same....

Thanks & Regards

Jai

Drilling Features

Fri, 19 Nov 2010 05:32:31 GMT

I am not able to view your dashboard as i am using the personal edition , so i need the steps to do so, kindly help with the same .

thanx in advance

Drilling Features

Fri, 19 Nov 2010 08:04:05 GMT

Step 1:

Select your chart and go to "Dimension" tab

Step 2:

In that left side near bottom you can see "Edit Groups" button.Click that you will get "New" button.Clik "New" button you will get fields which you having in youe application

Step 3:

Now you can select the select field in which manne they want to show in the object.Add in that manner.

Step 4:

Click "Ok" you will reach "Dimension" tab again.Now you can add Drill group which newly created,can be added as a dimension

in tab.

I hope it is clear.If you have any query let me know the same.

Thanks & Regards

Jai

Drilling Features

Tue, 23 Nov 2010 10:32:09 GMT

Thanx I have done with it, but i was not able to do with the way u suggested , insted i had to create year and month column in the data itself,

anyways thanx a lot for ur help

Drilling Features

Tue, 23 Nov 2010 13:43:39 GMT

Hi,

In my second and fourth post I have shown you how to take Year & Month from data itself.I hope I am clear.For further query let me know the same.

Thanks & Regards

Jai