Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hyperlink on Dimension

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

1 Solution

Accepted Solutions
sunny_talwar

Check the attached now

View solution in original post

6 Replies
sunny_talwar

May be like this?

Capture.PNG

Anonymous
Not applicable
Author

Sunny Thanks for the Help.

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

sunny_talwar

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.


Anonymous
Not applicable
Author

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)

sunny_talwar

Check the attached now

Anonymous
Not applicable
Author

Thanks sunny .

It Worked