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: 
abhirup99
Contributor III
Contributor III

List Box attributes to represent data both as Text and Link

Hi Team,

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

DomainWeb_UrlZoneRegistrations
ABChttps://www.aaa.comEast10
ABChttps://www.aaa.comWest12
ABChttps://www.bbb.comEast15
ABChttps://www.ccc.comEast20
PQhttps://www.ppp.comEast4
PQhttps://www.ppp.comWest7
PQhttps://www.qqq.comEast8


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

List Box:

DomainWeb_URL

 

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

LevelTotal Registrations
ABC57
PQ19

 

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.comhttps://www.ppp.com, https://www.qqq.com in LINK format:

LevelTotal Registrations
https://www.aaa.com22
https://www.bbb.com15
https://www.ccc.com20
https://www.ppp.com11
https://www.qqq.com8

 

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.

3 Replies
raman_rastogi
Partner - Creator III
Partner - Creator III

Try this

Make calculated dimension 

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

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

Expression -Sum(Registrations)

Regards

Raman

abhirup99
Contributor III
Contributor III
Author

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.