Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Drill Down

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

1 Solution

Accepted Solutions
prma7799
Master III
Master III

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

->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

View solution in original post

7 Replies
prma7799
Master III
Master III

PFA

Not applicable
Author

Hi

Can u please explain ?

Not applicable
Author

Got it Thanks u so much

prma7799
Master III
Master III

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

->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

Not applicable
Author

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

prma7799
Master III
Master III

Give me some example what you want.

Not applicable
Author

Hi

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