topic Re: Strugguling with the QlikView Requirement on hyperlink on measures through next level of drill down in QlikView

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

Mon, 15 Sep 2014 18:32:25 GMT

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

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

marcus_sommer — Tue, 16 Sep 2014 00:51:28 GMT

Maybe you could use conditions on your dimensions:

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

- Marcus

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

Tue, 16 Sep 2014 10:06:01 GMT

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

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

marcus_sommer — Tue, 16 Sep 2014 10:19:54 GMT

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

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

Tue, 16 Sep 2014 10:29:13 GMT

Hi Marcus in Qlikview we can't do hyperlinks like stuff to show case on measure value like

Amount

190

-7

on click a event should populate where a extra dimension to be added

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

marcus_sommer — Tue, 16 Sep 2014 10:40:59 GMT

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