Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Country | Region | Issuing Office | Sales | Gross | Variance Amount | |
---|---|---|---|---|---|---|
IND | ASIA | 2 | 123 | 313 | 190 | |
12 | 5 | -7 | ||||
US | North | 154 | 180 | 26 | ||
32 | 34 | 2 |
Showing sample table where the default Dimensions are Country,Region,Issuing Office,
Measure are Sales,Gross,Variance Amount.My problem is on clicking Measure say Variance Amount value say 190 first value, Drill down should happen which means next dimension level i.e' Authority' is also added along with default dimensions.Variance Amounts act like a hyperlink
Maybe you could use conditions on your dimensions:
Authority: if(getselectedcount(DIMENSION) = 1, true(), false())
- Marcus
Hi Friends,New to Qlik can any one explain in detail how to do on this doing POC please guide me
For charts isn't any OnClick-event available. You could only use the fact that such a click will lead to a selection which could be used for conditions on dimensions (like above) or trigger any action.
An alternatively could be to use an extension, maybe you will find here some usefully information:
http://community.qlik.com/search.jspa?q=extension+chart+onclick
- Marcus
Hi Marcus in Qlikview we can't do hyperlinks like stuff to show case on measure value like
Amount
190
-7
26
2
on click a event should populate where a extra dimension to be added
QlikView had no native OnClick-event on measures unless you used textboxes or buttons for this.
As workaround you could create another measure with a hyperlink beside your "Variance Amount" and use these link. Also the approach to use drill-down groups could be useful for you.
- Marcus