Discussion board where members can get started with QlikView.
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.
If I'm clicking e.g. 3 at the table cell and data like this should be shown:
First name/ Last name/age
Could I get an description/exple?
Please find attached the solution Qvw for your reference.
please let me know in case any query
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?
please find below descriptions.
1. i have combined the required fields :-
** ******************Script Start*****
// Loading Sample 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
GENDER&'/'&Firstname&'/'&Lastname&'/'&age as Combine // combining required fields
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 Expression
2.2 on second table i have used Combine field as dimension and Count(GENDER) as Expression.
2.3 i have used show hide chart condition based on the selection of GENDER
2.4 At last i have hide the expression by using Hide Column option under Presentation Tab
Please let me know in case any query.