Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
ekaponkratova
Creator
Creator

Set analysis - show only the current year FOR THE GRAPH doesnt work

Thanks to Radoresk

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))

11 Replies
ekaponkratova
Creator
Creator
Author

q_14.png

Bloody chart! Well, fixing is achieved. Just not correct fixing )

ekaponkratova
Creator
Creator
Author

Thank you, Radoresky!