topic Re: Details behind a Summarized Chart in QlikView

Details behind a Summarized Chart

Wed, 19 Mar 2014 13:51:35 GMT

Hi guys,

Noobie here - I have a situation where I'm looking at a group of summarized charts regarding transaction information. It's tracking # Transactions, # Errors and Average Run time. Let's use #Errors as an example - I have a drill down group create using Year -> Month -> Day - Hour displayed in a bar chart. Now if the #Errors is high and they want to investigate and look at the Transaction ID's for the time period they drilled into. How can that be done? A Table Box doesn't seem to work.

I appreciate any feedback!

Matt

Re: Details behind a Summarized Chart

cgdonders — Wed, 19 Mar 2014 14:26:03 GMT

Hi Matthew,

I assume you only want to present the details of the transactions that are related to an error. In this case you can use a stright table or a pivot table. A table box won't work because you can't use expressions in that object. You have to use expression sum(errors) in the expression or in your dimension (if...then...else...). see attached image.

example: If you want to use a straight table, you can have TRAN_ID as dimension and sum(errors) as expression. You can hide column sum(errors) on tab 'Presentation'.

Re: Details behind a Summarized Chart

Wed, 19 Mar 2014 14:39:54 GMT

Thank you Coen! I appreciate the fast response and correct answer! I initially had my expressions crossed and that's why I wasn't seeing the id's for the errors. I'll use the conditional if then else so I can see the details for both aggregates! Thanks again!

Matt