topic Re: SUM BETWEEN in QlikView

SUM BETWEEN

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I would like a sum of customers who depends on two condtions of sum

I made the following calculation but that does not give me the good result.

sum( {<[Code Client]={"= sum ({<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde )>2 and

sum ({<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde )<=5 "}>} Occurrence_Client )

Can you help me? Thank you

Re: SUM BETWEEN

Anil_Babu_Samineni — Wed, 29 Nov 2017 15:55:51 GMT

Expression sees okay, What it can be used of 2 double quotes in your nested analysis?

Re: SUM BETWEEN

sunny_talwar — Wed, 29 Nov 2017 15:59:22 GMT

Have you tried to create a chart with Code Client as a dimension and these two expressions to see if any of the code client meet the criteria?

=Sum({<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde) > 2

=Sum({<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde) <= 5

Re: SUM BETWEEN

Anonymous — Wed, 29 Nov 2017 16:42:55 GMT

excuse me I did not understand your question.The only thing that is used between the quotes are notions of dates

Re: SUM BETWEEN

Anonymous — Wed, 29 Nov 2017 16:49:05 GMT

yes, and I have clients who meet both criteria

thanks

Re: SUM BETWEEN

sunny_talwar — Wed, 29 Nov 2017 16:52:10 GMT

If that is the case, then I don't see why it isn't working.... Can you add this expression to the table above

Sum({<[Code Client] = {"=Sum({<[Date Commande] = {"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde ) > 2 and Sum({<[Date Commande] = {"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde) <= 5"}>} Occurrence_Client)

Re: SUM BETWEEN

Anonymous — Thu, 30 Nov 2017 09:31:12 GMT

too bad but it doesn't work

thanks

Re: SUM BETWEEN

Anil_Babu_Samineni — Thu, 30 Nov 2017 09:37:19 GMT

Can you share application to investigate where this not working?

What are you getting when you use this?

Sum({<[Code Client] = {"=Sum({<[Date Commande] = {">=$(=vDate24mois) <=$(=vDateFinSeg)"}>} Occurrence_Cde ) > 2 and Sum({<[Date Commande] = {">=$(=vDate24mois) <=$(=vDateFinSeg)"}>} Occurrence_Cde) <= 5"}>} Occurrence_Client)

Re: SUM BETWEEN

sunny_talwar — Thu, 30 Nov 2017 12:59:50 GMT

What does it show in the chart? Image? Better still, can you share a sample?

Re: SUM BETWEEN

Anonymous — Thu, 30 Nov 2017 16:54:09 GMT

here is a lighter version of the model. It's weird the calculation is unstable when I open the number of clients that meet the criteria is 2 and when I click on a client it goes to 4

thank you for your help

Re: SUM BETWEEN

Anonymous — Thu, 30 Nov 2017 16:58:12 GMT

here is a lighter version of the model. It's weird the calculation is unstable when I open the number of clients that meet the criteria is 2 and when I click on a client it goes to 4 thank you for your help

Re: SUM BETWEEN

sunny_talwar — Thu, 30 Nov 2017 17:00:35 GMT

You have on open trigger which restrict the date to a range.... basically only two clients are available for the date selection made

and when you clear, there all clients are available and only two meet the condition... what is the expected output when you open?

Re: SUM BETWEEN

sunny_talwar — Thu, 30 Nov 2017 17:01:47 GMT

May be you need this

=Sum({<[Code Client]={"=Sum ({1<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde) > 2 and Sum ({1<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde )<= 5"}, [Date Commande]={">=$(=vDate24mois) <=$(=vDateFinSeg)"}>} Occurrence_Client)

Re: SUM BETWEEN

Anonymous — Fri, 01 Dec 2017 10:16:30 GMT

Hello,

In fact what I want is on customers who ordered over the period from October 10 to November 21.Look their buying behavior over the last 24 months and count only those whose number of orders are between 2 and 5 over the last 24 months

Thank you

Re: SUM BETWEEN

Anonymous — Fri, 01 Dec 2017 10:23:03 GMT

I have the impression that with this formula I will count all the customers having a number of order between 2 and 5 over the last 24 months. Or I want this count only on the customers selected during the period from October 10 to 21 November

thanks for your help

Re: SUM BETWEEN

Anonymous — Sat, 02 Dec 2017 18:25:30 GMT

sorry you were right the last calculation is good with all these formulas I'm a little lost
thank you very much