Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Click on a calculated field to see associated dataset

Hi,

Im not a developer but have been working with our developers to create a number of reports. In our reports we use pviot tables which has a number of calculated fields. So what we want to do is to click on a cell which has a calculated fields and then see the associated dataset. The default QlikView behaviour does not allow selection beased on calculated field so was wondering if anyone knew or had examples of how to achive this.

Please see attached screenshot, the coloured columns are calculated fields and when I click on one of the cell values I would like to see the assopciated data sets on the "Aging Report Details Tab". Aging Report Details have all the data used in the report in a stright table.

Many Thanks,

Khan

1 Solution

Accepted Solutions
Not applicable
Author

Managed to solve this after lot of dingging around in the forum. Please the following thred:

http://community.qlik.com/message/46430#46430

I split the table into 3 seprate table "Overdue", "Due in 9 Days" and "Good"

So for the Overdue table:

I used the calculated dimension (Overdue) which had a value of "Ture" or "False" (but I had only selected to show the records which were "True") and inserted it in my pivot table (far left of the table) and then hidden it from view. So when the users clicked on the calculated field it retruned records which had a "Overdue" value of "True".

Applied the same logic to the other 2 tables as well

Bingo!!

Khan

View solution in original post

1 Reply
Not applicable
Author

Managed to solve this after lot of dingging around in the forum. Please the following thred:

http://community.qlik.com/message/46430#46430

I split the table into 3 seprate table "Overdue", "Due in 9 Days" and "Good"

So for the Overdue table:

I used the calculated dimension (Overdue) which had a value of "Ture" or "False" (but I had only selected to show the records which were "True") and inserted it in my pivot table (far left of the table) and then hidden it from view. So when the users clicked on the calculated field it retruned records which had a "Overdue" value of "True".

Applied the same logic to the other 2 tables as well

Bingo!!

Khan