Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I use the P&L Pivot with the function FirstSortedValue ( to make a TOP of max value by month for production workshop)
I have a table with the PERIOD, WORKSHOP , VALUE , ACTIVITIE ( is a type of VALUE )
So in my case , I use this function to show the first workshop
=(FirstSortedValue ({<ACTIVITIE = {'Ton month'},Pays = {'France'},PERIOD = {">=$(=MonthStart(Max(PERIOD), -11))<=$(=MonthEnd(Max(PERIOD)))"}>} WORKSHOP, -VALUE,1))
And this to show the value :
=(FirstSortedValue ({<ACTIVITIE = {'Ton month'},Pays = {'France'},PERIOD = {">=$(=MonthStart(Max(PERIOD), -11))<=$(=MonthEnd(Max(PERIOD)))"}>} VALUE, -VALUE,1))
Only the value is display but not the name of workshop.
I use this function with a Qlik sense pivot graphic and it’s ok. Could you help me ?
Thank you