Problems with Expressions

Anonymous — Tue, 22 Jul 2014 18:07:44 GMT

Hi,

I have a problem with variables.

I load variables from a spreadsheet, and it contains the necessary calculations for the formulas in the application.

I realized that if a reference that will query the two records, it multiplies the original value by the amount of logging.

example:

Ref Value Discont1 Discount2

3815738 500.00 250.00 0.00

3815738 500.00 0.00 250.00

In the charts this reference is:

Ref Value Discont1 Discount2

3815738 1000.00 250.00 250.00

The value of the variable is:

sum ({<[Course type] = {"> 1 <3"}>} VALORORIG_MENSALID)

It is called in the following chart:

$(vMensal_Grad)

If I add the DISTINCT, the value of the variable, it will only sum the distinct values with this value be unreal.

example:

Without DISTINCT: 20 million

With DISTINCT: 2 million

How do I make it add up the values of distinct references, and not of distinct values?

I hope I have managed to demonstrate the problem.

Re: Problems with Expressions

vadimtsushko — Wed, 23 Jul 2014 09:14:30 GMT

Hi Bruno.

Should you prepare an example of application with your data and current expresssions and add comment or excel table with desirable results, I believe community would have better chance to help you

Best regards, Vadim

topic Problems with Expressions in QlikView

Problems with Expressions

Re: Problems with Expressions