-
Re: ignore selcetions qlik sense
Sunny Talwar Sep 26, 2017 7:35 AM (in response to Joanna Seldon)This doesn't ignore selection in Year? Is your Year field called Year or something else?
RangeAvg(Above(Count(DISTINCT{$<Department -= {'Catering'}, Year =>} [OrderID]), 0, 53))
-
Re: ignore selcetions qlik sense
Joanna Seldon Sep 26, 2017 7:40 AM (in response to Sunny Talwar )Hi
it does not seem to , as the rolling average number slightly changes when you select a year..
I want a user to select a year of their choice and the rolling average figures are un affected (not changed)..
this process normally works using the Year = for other set analysis measures..but does not seem to work for using the n period calculation using RangeAvg(above (Count
please help
-
Re: ignore selcetions qlik sense
Sunny Talwar Sep 26, 2017 7:42 AM (in response to Joanna Seldon)I am not sure if you can share a sample or not, but it might help to look at it to figure out what might be wrong here
-
Re: ignore selcetions qlik sense
Joanna Seldon Sep 26, 2017 7:59 AM (in response to Sunny Talwar )Hi
I cant sorry
but I have the dimension Weekend(OrderDate)
Measure 1 count(OrderID)
measure 2 rangeavg(above(Count( distinct{$< Department -= {'Catering'}, Year =>}[OrderID] ),0,53))
When the user selects Year, the first measure should change..but the second measure should remain unaffected
as using the Year= in the set analysis
the number for example before you select is
for example weekend date is
count 2216 (Measure 1)
Avg 2586 (Measure 2)
pick a year and I get
count 2216 (Measure 1)
Avg 2356 (Measure 2)
I think it does not work well with rangeavg functions
please help
-
Re: ignore selcetions qlik sense
Sunny Talwar Sep 26, 2017 7:59 AM (in response to Joanna Seldon)Don't know my friend... sorry
-
Re: ignore selcetions qlik sense
Joanna Seldon Sep 26, 2017 8:01 AM (in response to Sunny Talwar )Hi
is there another way / code type in qlik sense to ignore selections?
I fount concat..but I don't think I am doing it right
Kind Regards
-
Re: ignore selcetions qlik sense
Sunny Talwar Sep 26, 2017 8:03 AM (in response to Joanna Seldon)This is the only way it was introduced to me... I am unaware of another way... but may be someone else can help you
-
Re: ignore selcetions qlik sense
Joanna Seldon Sep 27, 2017 6:49 AM (in response to Sunny Talwar )Hi
in a post you replied to
so I am now using the code you provided...
RangeAvg(Below(Count( Distinct {1< Year=>} [OrderID]), 0, 52))
I still need when a user selects a year from the filer pane , the measure is unaffected
however using the Year= still does not work
I have had to change the above code to Above instead of below..as the number will be slightly out otherwise too
so it looks like
RangeAvg(Above(Count( Distinct {1< Year=>} [OrderID]), 0, 52))
any more ideas please
Kind Regards
-
Re: ignore selcetions qlik sense
Sunny Talwar Sep 27, 2017 7:04 AM (in response to Joanna Seldon)Nope still no idea... I am really sorry Joanna.. I am not sure what you have at your end... and without knowing, it will be very difficult to say anything
-
Re: ignore selcetions qlik sense
Joanna Seldon Sep 27, 2017 7:18 AM (in response to Sunny Talwar )Hi
is there a way in qlik sense please, that say a year is selected , that the measure can disappear or hide (Line on chart), as I don't want it to show the wrong values when a year is selected?
Kind Regards
-
-
-
-
-
-
-
-
-