Count not Counting

[MikeJones]

Hi, I have table in Qlik Sense with a measure count([Qlik_NMTKPI3.Jobid]), Jobid and other dimension variables.

Below is a snapshot of my output.  The count is only showing as 1, when it should be 4.

count([Qlik_NMTKPI3.Jobid])	Jobid
1	136748655
1	136748655
1	136748655
1	136748655

[Or]

"Other dimension variables"? You may want to elaborate...

[JandreKillianRIC]

Hi @MikeJones 

Also in agreement with @Or . 

What are the other dimensions and variables. If you do a count([Qlik_NMTKPI3.Jobid]) as measure and Jobid as Dimension this should give you 4. 

Regards Jandre

[Aditya_Chitale · Accepted solution]

I agree with @Or ,

but if you still want to show the count ignoring other columns, try:

Aggr(nodistinct count([Qlik_NMTKPI3.Jobid]), [Qlik_NMTKPI3.Jobid])

Regards,

Aditya

[MikeJones · Accepted solution]

Hi Or and Aditya, thanks for replying to my question.

I have used Aditya's proposal and it works.

[Aditya_Chitale]

If the solution worked for you, kindly mark it as accepted.

Regards,

Aditya