topic Drill Down in QlikView

Drill Down

Mon, 27 Apr 2015 11:26:13 GMT

Hi All ,

I have attached a file in that i want date vs AVG(Date accuracy) then if i click on particular date it should drill down to the data source(there are 4 data sources) level and it has to show 4 data sources for that date

Can anyone help me out for this??

Thanks,

Soumya

Re: Drill Down

prma7799 — Mon, 27 Apr 2015 11:33:48 GMT

PFA

Re: Drill Down

Mon, 27 Apr 2015 11:37:30 GMT

Can u please explain ?

Re: Drill Down

Mon, 27 Apr 2015 11:42:43 GMT

Got it Thanks u so much

Re: Drill Down

prma7799 — Mon, 27 Apr 2015 11:45:37 GMT

first load data as it is

then create on bar chart in the dimension

->go to edit group to create drill down and cyclic group

->then New

->give group name what you want

->then select drill down or cyclic group

->then select data and date source from available fields

->ok

->the go to expression put avg([Data Accuracy])

->in the expression tab tick on" values on data point"

->then go to axis tab tick on show grid

->ok

Re: Drill Down

Mon, 27 Apr 2015 11:48:21 GMT

Yeah thanks a lot

And one more thing for the same I want to show date field as today ,last week ,last month like that in list box ??

Please help me out

Thanks ,

Soumya

Re: Drill Down

prma7799 — Mon, 27 Apr 2015 12:01:57 GMT

Give me some example what you want.

Re: Drill Down

Tue, 28 Apr 2015 05:52:31 GMT

This is correct but First i want to show Date VS avg(Data accuracy) then if u click that Date accuracy i need all 4 data sources at once for all the dates not single date

In the above example if drill down its showing data sources only for one date

Can u help me out?

Thanks ,

Soumya