Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Count Distinct and Concatenate not filtering with other Dimensions

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

Highlighted
Champion II
Champion II

Re: Count Distinct and Concatenate not filtering with other Dimensions

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

Highlighted
Not applicable

Re: Count Distinct and Concatenate not filtering with other Dimensions

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.



Highlighted
Champion II
Champion II

Re: Count Distinct and Concatenate not filtering with other Dimensions

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

Highlighted
Not applicable

Re: Count Distinct and Concatenate not filtering with other Dimensions

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

Highlighted
Champion II
Champion II

Re: Count Distinct and Concatenate not filtering with other Dimensions

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

Highlighted
Not applicable

Re: Count Distinct and Concatenate not filtering with other Dimensions

Same result.

Highlighted
Not applicable

Re: Count Distinct and Concatenate not filtering with other Dimensions

Sunny,

What you need to view a sample?

Thanks

Highlighted

Re: Count Distinct and Concatenate not filtering with other Dimensions

I was hoping for a qvw file with the desired output

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample