List Box attributes to represent data both as Text and Link

[abhirup99]

Hi Team,

I have 4 attributes Website, Web_url, Zone, Registrations in my data.

Domain	Web_Url	Zone	Registrations
ABC	https://www.aaa.com	East	10
ABC	https://www.aaa.com	West	12
ABC	https://www.bbb.com	East	15
ABC	https://www.ccc.com	East	20
PQ	https://www.ppp.com	East	4
PQ	https://www.ppp.com	West	7
PQ	https://www.qqq.com	East	8

Now when my visualization in Qlik Sense is having a list box with two values like :

List Box:

Domain

Web_URL

When in List Box "Domain" is selected the straight table below should show values like below with ABC and PQ in text format:

Level	Total Registrations
ABC	57
PQ	19

When in List Box "Web_URL" is selected the above straight table should show values like below with https://www.aaa.com, https://www.bbb.com, https://www.ccc.com, https://www.ppp.com, https://www.qqq.com in LINK format:

Level	Total Registrations
https://www.aaa.com	22
https://www.bbb.com	15
https://www.ccc.com	20
https://www.ppp.com	11
https://www.qqq.com	8

Presently I am able to view both Domain and the Web_URL values under 'Level' column either as TEXT or as LINK. 

But my requirement is to have the Domain values represented as TEXT and Web_URL values represented as LINK.

Please guide me with the above requirement.

[raman_rastogi]

Try this

Make calculated dimension 

ex- if(getSelectedField('ListBox')='Domain',Domain,

      if(getSelectedField('ListBox')='Web_URL',Web_URL,))

Expression -Sum(Registrations)

Regards

Raman

[abhirup99]

Hi Raman,

Thanks for your suggestion !

I am doing this. But my requirement is to show the Domain values in TEXT format and Web_URL values as hyperlinked formats.

I am unable to achieve it. Either they are in text format for Hyperlinked format.

[raman_rastogi]

Hi Abhirup,

Below link might be useful.

https://community.qlik.com/t5/New-to-QlikView/How-to-add-hyperlink-into-the-field/td-p/372544

https://community.qlik.com/t5/QlikView-Management/URL-Link/td-p/431056

Regards

Raman