Please, help me. I'm an intern. :woman_technologist:

[HanaKovacevic0001]

Hi guys! I'm a newbie at Qlik and an intern at a major company. I have received some code to debug and of course, I'm getting some issues with it.

First of all, I'd like to thank anyone that even tries to help.

Second of all, here's the issue:

num Sum ([[SetExpression] [DISTINCT] [ALL] [TOTAL] [< fld ExpressionFieldRef {,fld ExpressionFieldRef } >]] } expr Expression)

I have no clue what that means. I'm aware that it's written in SQL, but this is the formula that's been creating some issues for my client. 

Please help. 

 👩‍🔧👩‍💻

[Anil_Babu_Samineni · Accepted solution]

Welcome to the Qlik board !!

Explanation: They are trying to aggregate the sum of Expression {Measure Data Points} for all unique number with All kind of aggregate fields using All needed fields.

Syntax: Sum({<Dimension = {'1'}>} TOTAL <Field1, Field2> DISTINCT Expression) 

Above Measure is calculating for Expression of Sum of unique values for the Dimension value as "1" of the each Field division of the TOTAL.