Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
aaryanqvdevelop
Creator
Creator

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

aaryanqvdevelop
Creator
Creator
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.


aaryanqvdevelop
Creator
Creator
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

View solution in original post

aaryanqvdevelop
Creator
Creator
Author

Thanks sunny .

It Worked