Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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