topic Hyperlink on Dimension in QlikView

Hyperlink on Dimension

Anonymous — Thu, 14 Apr 2016 13:11:46 GMT

Hi,

I have dataset with 3 columns

ErrorID Status Priority Date

101 Assigned High 01/04/2016

102 Resolved Medium 01/04/2016

103 Closed Low 01/04/2016

104 Assigned High 04/04/2016

105 Resolved Medium 04/04/2016

106 Closed Low 05/04/2016

107 Assigned High 11/04/2016

108 Resolved Medium 11/04/2016

109 Closed Low 11/04/2016

Dimension : ErrorID,Status,Priority

Expression : Count({<Status={'Assigned'},Priority={'High'},Date={>Date('07/04/2016')}>}ErrorID) + Count({<Status={'Assigned'},Priority={Low},Date={>Date('03/04/2016')}>}ErrorID)

O/p

ErrorID Status Priority Count

107 Assigned High 1

106 Closed Low 1

109 Closed Low 1

Now I want to add link on ErrorID. how do I do that. So that when I click Error ID it takes user to web page

Re: Hyperlink on Dimension

sunny_talwar — Thu, 14 Apr 2016 13:18:54 GMT

May be like this?

Re: Hyperlink on Dimension

Anonymous — Thu, 14 Apr 2016 13:21:17 GMT

Sunny Thanks for the Help.

There is small change in the Expression i forgot to mention in the previous post

Re: Hyperlink on Dimension

sunny_talwar — Thu, 14 Apr 2016 13:24:03 GMT

Have you tried opening the sample I attached? I think you will get the idea of what I am doing. Use the same set analysis for the ErrorID expression. I don't have the other data from your set analysis to implement into the sample.

Re: Hyperlink on Dimension

Anonymous — Thu, 14 Apr 2016 13:27:22 GMT

Yes with one Countit is working

Count({<Status={'Assigned'},Priority={'High'},Date={>Date('07/04/2016')}>}ErrorID)

but i with two Count im not getting

Count({<Status={'Assigned'},Priority={'High'},Date={>Date('07/04/2016')}>}ErrorID) + Count({<Status={'Assigned'},Priority={Low},Date={>Date('03/04/2016')}>}ErrorID)

Re: Hyperlink on Dimension

sunny_talwar — Thu, 14 Apr 2016 14:14:53 GMT

Check the attached now

Re: Hyperlink on Dimension

Anonymous — Thu, 14 Apr 2016 14:48:52 GMT

Thanks sunny .

It Worked