Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count Distinct and Concatenate not filtering with other Dimensions

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:

nivel criticidade.PNG

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.

9 Replies
sunny_talwar

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

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

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
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

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

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

Same result.

Not applicable
Author

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