Is there a way to drill through

[Anonymous]

Hi

I have a bar chart which shows the Utilization rate per a device.X axis is week , Y axis is Utilationrate .Bar's stacked by each device.

When i export the data to excel i get the utilization rate by each of the device and week,

The utilization rate is calculated by the expression availablehours divided by usedhours , is there a way in qlikview where i can have a link by clicking on which i get the values availablehours,usedhours,device and utilization rate into a excel form?Similar to drill through reports on cognos or Businesobjects ?

Thank you.

[prieper]

You may copy the existing graph, change to table and insert a condition to be visible, if there is only one dimension selected.

HTH
Peter

[#3]

How and where to insert a condition visible?

.....and does this give a hyper link , for eg , when user cliks on the link and the table appears with the values?

[prieper]

Easiest is to add under Properties - Layout - Show - Conditional

LEN(ONLY(YourField))>0

HTH
Peter

[#5]

What should i give in "YourField" in the above expression?

[prieper · Accepted solution]

see the attached

Peter