topic Re: Display Higher dimension in graphic in QlikView

Display Higher dimension in graphic

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

Hi Qlikers,

I have a table where persons can cumulate many functions at the same time.

I want to create a table (orange table in the qvw attached) ) which display only the higher function for each person at one time

(Priority of function are contained in a seperate table)

In my exemple i need to keep 2 lines in the orange table :

Joe > Director ...

marc > president ...

I would love to improve the "Nb persons" expression to achieve this, but other solutions are also welcome !!

Thanx for your help.

Re: Display Higher dimension in graphic

dplr-rn — Wed, 12 Sep 2018 14:25:18 GMT

Hi Maxime

this expression should work

count(aggr(max({<START ={"$(= '<=' & '$(v_cal)' )"},END ={"$(= '>=' & '$(v_cal)' )"}>}priority), person))

Re: Display Higher dimension in graphic

maxime66 — Thu, 13 Sep 2018 14:16:45 GMT

Hi Dilip,

thanx for your help.

It works for marc( = president)

but not for Joe (=worker, instead of Director) ...

Re: Display Higher dimension in graphic

dplr-rn — Thu, 13 Sep 2018 15:52:58 GMT

hm.. just realized the issue. the row has no association with aggr

you will need to use first sorted value function in some form to achieve what you want

simpler form e.g. =FirstSortedValue(function,-aggr(distinct max({<START ={"$(= '<=' & '$(v_cal)' )"},END ={"$(= '>=' & '$(v_cal)' )"}>}priority),person,function))

Re: Display Higher dimension in graphic

maxime66 — Fri, 14 Sep 2018 15:07:45 GMT

Hi Dillip,

It works with just person dimension displayed...

but i have to keep START and END dimensions too ... ( sorry it was not very clear in first post)

person	function	START	END	Nb persons
joe	director	01/02/2018	31/12/2018	1
marc	president	01/02/2018	31/12/2018	1

Thanks 4 your help !

Best regards.

Re: Display Higher dimension in graphic

dplr-rn — Fri, 14 Sep 2018 15:14:23 GMT

Hm. .. can't think of anything. Will check

Let me know if you find a solutions too

Re: Display Higher dimension in graphic

dplr-rn — Fri, 14 Sep 2018 15:34:54 GMT

May have cracked it. add expressions for start and end date in similar way

=Date(FirstSortedValue(START,-aggr(distinct max({<START ={"$(= '<=' & '$(v_cal)' )"},END ={"$(= '>=' & '$(v_cal)' )"}>}priority),person,function)),'DD/MM/YYYY')

didnt test it extensively though.

hope it works out 🙂

Re: Display Higher dimension in graphic

maxime66 — Wed, 19 Sep 2018 13:57:51 GMT

Thanks

Works fine .