Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
userchatel
Contributor
Contributor

How can I get value from a period of time

Hi guys, how are you doing ? 

I am currently having a problem with a value I'm trying to show.  I want to make a comparison between the revenue figures of the period of time selected in a filter pane and the same period beforehand (if I select 2015, it shows me the revenues of 2015 in a KPI indicator and have a second KPIindicator show the revenues of 2014). 

I have a function that works quite well that can show me the value 2014 when I select 2015 in the filter pane and I also made it do it with months and weeks.

Now I want to  get the data of 2014 of the revenues, how should I do it. 

My function to get 2014 : 

=If(GetSelectedCount('Année')>1, Num(SubField(GetCurrentSelections('Année'), ' ',-1),'0.0','')-1,  		
	If(GetSelectedCount('Mois')>1,      	     			
		Num(SubField(GetCurrentSelections('Mois'), ' ',-1),'0.0','')-1,           	
	Num(SubField(GetCurrentSelections('SemaineVolet'), ' ',-1),'0.0','')-1          	
		)      
	)

My variable to show my revenue is VAL_CA_TOTAL.

 

Thank you guys in advance

 

Labels (4)
0 Replies