topic Re: Calculate the difference between 2 dimensions in QlikView

Calculate the difference between 2 dimensions

ianweb100 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Calculate the difference between 2 dimensions

MarcoWedel — Fri, 17 Aug 2018 20:44:00 GMT

Hi,

one solution using alternate states could be:

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

hope this helps

regards

Marco

Re: Calculate the difference between 2 dimensions

ianweb100 — Fri, 17 Aug 2018 22:38:05 GMT

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

Re: Calculate the difference between 2 dimensions

MarcoWedel — Fri, 17 Aug 2018 22:51:04 GMT

You're welcome.

This example uses QlikView

Marco

Re: Calculate the difference between 2 dimensions

MarcoWedel — Fri, 17 Aug 2018 22:54:28 GMT

please close your thread if your question is answered

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

Re: Calculate the difference between 2 dimensions

ianweb100 — Sat, 18 Aug 2018 05:36:27 GMT

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

Re: Calculate the difference between 2 dimensions

MarcoWedel — Sun, 19 Aug 2018 21:51:53 GMT

Both are using QIX Engine

Re: Calculate the difference between 2 dimensions

ArnadoSandoval — Sun, 19 Aug 2018 23:58:03 GMT

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.

Re: Calculate the difference between 2 dimensions

ianweb100 — Mon, 20 Aug 2018 12:06:47 GMT

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.

Re: Calculate the difference between 2 dimensions

MarcoWedel — Thu, 23 Aug 2018 22:24:34 GMT

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

thanks

Marco