topic Re: Formula problem in QlikView

Formula problem

rolandg1881 — Tue, 25 May 2021 16:54:30 GMT

Hi!

Here is my special formula 😉 but i don't know why it won't work.

I only want to see set analysis choice but it does not work, for example i say that i only want to see the customer 70407 but in the list are also other customers.

Does anybody know whats wrong? Is it completly wrong what i do?

sum(aggr(sum({<[RMA_ClaimType]={'accepted claim'},[Customer_Number]={70407},[ArtikelBezCarbon]={'L1'},[RMA_Typ]={'Reklamation'},[Lagerort_Lieferung]-={'RMA Abgangslagerplatz'}>}DISTINCT[RechPos_RMA_Menge]),RMA_Id))

Thank you very much!

Re: Formula problem

QFabian — Tue, 25 May 2021 18:44:39 GMT

{'70407'}

Re: Formula problem

rolandg1881 — Tue, 25 May 2021 18:50:24 GMT

Hi!

Thank you but i dont think this is the solution, originally i had this syntax.

Greetings

Re: Formula problem

QFabian — Tue, 25 May 2021 18:59:28 GMT

sorry!, you have to reply the set analysis sintax for the AGGR aggregation too

Re: Formula problem

rolandg1881 — Tue, 25 May 2021 19:12:31 GMT

Hi!

I have only this formula. 😉

I want the summary of RechPos_RMA_Menge (=amount)

where the values are

[RMA_ClaimType] = {'accepted claim'}

[CustomerNumber] = {'70407'}

[ItemName] = {'L1'}

etc.

based on RMA_Id (Claim Id)

Greeitngs

Roland

Re: Formula problem

QFabian — Tue, 25 May 2021 19:17:25 GMT

Without data for testing,, i should use something like this :

sum(
{< RMA_ClaimType = {'accepted claim'}, CustomerNumber = {'70407'}, [ItemName] = {'L1'} >}
aggr(
{< RMA_ClaimType = {'accepted claim'}, CustomerNumber = {'70407'}, [ItemName] = {'L1'} >}
sum(
{< RMA_ClaimType = {'accepted claim'}, CustomerNumber = {'70407'}, [ItemName] = {'L1'} >}
RechPos_RMA_Menge)
,RMA_Id))

Re: Formula problem

rolandg1881 — Tue, 25 May 2021 19:20:18 GMT

Thank you very much!

I will try this and give you reply.

Greetings

Roland