Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
I have the following data set it contains 1000 occupations and 13000 skills , i want to create a visualization where I user pick occupation twice, one is their starting occupation and the other their target occupation and in a separate table we show the skill they need to get the other occupation, therefore this function(calculation) must be dynamic
Occupations | Skills |
---|---|
Chef | Cook |
Chef | Manage Staff |
Chef | Budget |
Programmer | Python |
Programmer | Budget |
Programmer | R |
So in this case someone picked chef and picked programmer, therefore the difference in Python
Occupation S | Occupation T | Skils you need |
---|---|---|
Chef | Programmer | Python |
R |
How do I code to find this difference everytime someone pick one 2 or more Occupation S and the Occupation T??
tks a lot
Hi,
one solution using alternate states could be:
Concat({1<Skills=p({sTarget} Skills)-p({sStart} Skills)>} DISTINCT Skills, ', ')
hope this helps
regards
Marco
Hi Marco , tks for the super comprehensive reply . I will try at work monday. Are you using Qlik sense or view? Or does not matter ? Sorry Im really new to Qlik
You're welcome.
This example uses QlikView
Marco
please close your thread if your question is answered
Qlik Community Tip: Marking Replies as Correct or Helpful
thanks
regards
Marco
Does Qlik view uses same language then sense? I personally do not understand why 2 products , its confusing.
Both are using QIX Engine
Hi Ian,
QlikView and QlikSense share the syntax for the same scripting language, the one we use to load data and create QVDs, both of them can load QVDs created by the other one. QV and QS differ in their user interfaces. QlikView is older and building its user interface is done by enabling/disabling properties, programming events, and some nice features to handle the data presentation, while QlikSense is newer, about 3 years old, it thrives in Web environments.
Hi Marco I tried to implement solution in Qlik sense but it did not work.That is no definition field in Sense, and when I enter the function Concat({s Start}).... it mention invalid, i will post a snippet tomorrow morning.
please close this QlikView related thread and open another one in the sense forum.
thanks
Marco