Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Desauv
Contributor
Contributor

Only sum projects between to values

Hi

If I want to change "Faktureret" from being different from "0", to being between to values. For example between 0.01 and 100000 how do i do that?

Thanks for the help 🙂

 

Sum (
{<
	Date_num_afsl = {"<=$(=num(floor(MonthEnd(Max(Dato_NUM_Tid))))), >=$(=num(monthstart(Min(Dato_NUM_Tid))))"},
	[År Tid] =,
	[Måned Tid] =,
	[År (Regnskab) Tid]=,
	IGVA_DATO =,
	//Faktureret ={"<>0"}
	Projektnr = {"*"}-{''},
	>}


Faktureret)

 

Labels (1)
1 Reply
jwaligora
Creator II
Creator II

Temporarily ignoring all your other rules, I think you may just be looking for this:

=sum({<Faktureret={">=0.01<=100000"}>} Faktureret)