Calculate the difference between 2 dimensions

[ianweb100]

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

[MarcoWedel]

Hi,

one solution using alternate states could be:

Concat({1<Skills=p({sTarget} Skills)-p({sStart} Skills)>} DISTINCT Skills, ', ')

hope this helps

regards

Marco

[ianweb100]

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

[MarcoWedel]

You're welcome.

This example uses QlikView

Marco

[MarcoWedel]

please close your thread if your question is answered

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

[ianweb100]

Does Qlik view uses same language then sense? I personally do not understand why 2 products , its confusing.

[MarcoWedel]

Both are using QIX Engine

[ArnadoSandoval]

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.

[ianweb100]

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.

[MarcoWedel]

please close this QlikView related thread and open another one in the sense forum.

thanks

Marco