Count Distinct and Concatenate not filtering with other Dimensions

[#1]

Hi all,

I notice that after doing my Count Distinct and concatenate some values when I use in graph others Dimensions the result that i obtain is always the same in all dimensions result.

For example:

The formula I use is:

=count( DISTINCT {< Resultado={"Qualificado"}, Requalificacao={"0"}>} IdentificadorCandidatura & IdSubCategoria & ManufacturerNIF)

Some ideas whats is happening, the concatenate don't be able to use this kind of formula?

Thank in advance.

[sunny_talwar]

Would you be able to share a sample to show the issue?

[vinieme12]

What exactly do you want to count? and what exactly do you want to concatenate?

[#4]

Hi Vineeth,

I have this concatenate in the formula above "IdentificadorCandidatura & IdSubCategoria & ManufacturerNIF".

This formula is my expression, "=count( DISTINCT {< Resultado={"Qualificado"}, Requalificacao={"0"}>} IdentificadorCandidatura & IdSubCategoria & ManufacturerNIF)"

I put a dimension do "sort" the data by, for example [Nivel], like in the image above.

But the result for each [Nivel] is the same "212" for each category.

[vinieme12]

I don't get why there is a need to count on 3 fields? also are these fields from the same table or associated tableS

[#6]

I need to do a Distinct with this 3 fields. The 3 are from the same table.

[vinieme12]

This will never work, create a new concatenated field during load to count on

example

LOAD *,

IdentificadorCandidatura &'_'& IdSubCategoria&'_'&ManufacturerNIF as NEWFIELD

and use this field in your expressions

[#8]

Same result.

[#9]

Sunny,

What you need to view a sample?

Thanks

[sunny_talwar]

I was hoping for a qvw file with the desired output

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample