Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
tschi2002
New Contributor

DrillThrough posible?

Hello QlikView comunity,

I'm very new in QlikView and made my first steps to create complex reports discribed here in the comunity.

First report with dynamical dimensions has been implemented successfully. Many thanks for this.

But what I can not found is a description for drill through. Please no Drill Down.

A have a table and clicking on one cell should shown an additional table with data for this cell.

e.g.

Gender  Count

W           1

M           3

If I'm clicking e.g. 3 at the table cell and data like this should be shown:

First name/ Last name/age

A/B/12

C/B/24

D/T/70

Could I get an description/exple?

Many thanks

4 Replies
tschi2002
New Contributor

Re: DrillThrough

Hello experts,

any ideas?

Thanks

Partner
Partner

Re: DrillThrough

Hi,

Please find attached the solution Qvw for your reference.

first.PNG

second.PNG

please let me know in case any query

Regards,

Bhasker Kumar

tschi2002
New Contributor

Re: DrillThrough posible?

Hello,

thanks a lot for your solution.
I'm using the Version QlikView 12.20.20400.0 and can not open your example. Could you descibe it please? Or send me a version a will be able to open?

Many thanks
Alex

Partner
Partner

Re: DrillThrough posible?

Hi,

please find below descriptions.

1. i have combined the required fields :-

** ******************Script Start*****

// Loading Sample data

Data:

Load * Inline [

GENDER, Firstname, Lastname, age

M, A, B, 12

M, C, B, 24

M, D, T, 70

F, E, G, 34

F, J, K, 25

F, Z, X, 26

];

Test1:

LOAD

GENDER,

GENDER&'/'&Firstname&'/'&Lastname&'/'&age as Combine  //  combining required fields

Resident Data;

DROP Table Data;

2. On front end i have used two pivot table and conditional show hide- based on the selections.

     2.1-> on First table i have simply took Gender as Dimension and Count of Gender(Count(GENDER) as Expression1st.PNG

2.2 on second table i have used Combine field as dimension and  Count(GENDER) as Expression.

2nd.PNG

3rd.PNG

2.3 i have used show hide chart condition based on the selection of GENDER

4th.PNG

2.4 At last i have hide the expression by using Hide Column option under Presentation Tab

5th.PNG

Please let me know in case any query.

Regards,

Bhasker