Discussion Board for collaboration on QlikView Scripting.
Dear Community! First of all thank you so much for being so helpful so fast when me and other users have needed help
I have a specific question... So I have a list of links, but I need to be able to add value and separate them from their content.
Lets say I have this:
I'd like to be able to build something that lets me say that:
IF URL CONTAINS
.CL, IT IS A WEBSITE FROM CHILE
.AR = ARGENTINA
.COM = INTERNATIONAL
Can anybody help me figure this one out?? Do I have to put this in the Load Script? Or can I just add a graph with a long expression?
If it helps, in Excel i solved showing the final bit of the link with this:
Go to Solution.
The best place is to add this expression in your load script where you load the URL field
pick(wildmatch(URL, '*CL', '*AR', '*COM'), 'IT IS A WEBSITE FROM CHILE', 'ARGENTINA', 'INTERNATIONAL') as URL_COUNTRY,
<more fields here>
Then you can use URL_COUNTRY as a dimension in your chart and count(URL) as the expression.
pick(wildmatch(URL, '*CL', '*AR', '*COM'), 'IT IS A WEBSITE FROM CHILE', 'ARGENTINA', 'INTERNATIONAL')
And how could I apply this??
I want to make a frequency chart that shows where the site is from and how many links the specific country has.
Thank you so much!! It works perfectly =) I had no idea about that function!