Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Thanks to Radoresky
at (https://community.qlik.com/t5/Qlik-Community-Help-Discussions/Set-analysis-show-only-the-current-yea...) we fixed one part.
Now, if I want to show the same calculation but as a trendline showing MoM trend, the below formula works but it changes as soon as a person made a selection. How could I make the graph static?
count({1}{1<[TimeStamp.Calendar.Year] = {"$(=year(today()))"},type={'move'},vessel_crane-={"=len(trim(vessel_crane))=0"},
visit-={"=len(trim(visit))=0"},CRANE-={"=len(trim(CRANE))=0"}>} container)
/sum({1}distinct {1<[TimeStamp.Calendar.Year] = {"$(=year(today()))"},vessel_crane-={"=len(trim(vessel_crane))=0"},
visit-={"=len(trim(visit))=0"},CRANE-={"=len(trim(CRANE))=0"}>}aggr((if(((t_max - t_min)*24) <0,0,(t_max - t_min)*24)), vessel_crane))
Bloody chart! Well, fixing is achieved. Just not correct fixing )