Strugguling with the QlikView Requirement on hyperlink on measures through next level of drill down

[#1]

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

[marcus_sommer]

Maybe you could use conditions on your dimensions:

Authority: if(getselectedcount(DIMENSION) = 1, true(), false())

- Marcus

[#3]

Hi Friends,New to Qlik can any one explain in detail how to do on this doing POC please guide me

[marcus_sommer]

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

http://market.qlik.com/

- Marcus

[#5]

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

[marcus_sommer]

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