Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

calculation distinct

Hi

How to count the number of ranches in which there document.2 ?

Thank you

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

hi

Try this expression

= count(DISTINCT aggr(count( if(document<>'document2', branch)),branch))

removed DISTINCT inside aggr, just try it.

Pls. see attachement

View solution in original post

13 Replies
Highlighted

A Straight Table with :

  • Dimension    document
  • Expression  = Count (  distinct branch )


Will give the count of ranches for each document.

You can select document2 if that is the only one you wish to see.

Highlighted
Partner
Partner

Hi Marina,

see the additional table in the attached.

HTH

Andy

Highlighted
Not applicable

It is not exactlyScreenshot_1.png

Highlighted
Master
Master

Hi,

May be like this,

Dimension:

branch

Expression:

=Count(DISTINCT{<document={'document2'}>}document)

Distinct-205167.PNG

Hope this helps,

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
Not applicable



I'm looking for the number of branches that do not have a document 2

Highlighted
Not applicable

Screenshot_2.png

Highlighted
Master
Master

Hi,

Check this,

Can you explain a bit more ! Your output required.

PFA

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
Specialist III
Specialist III

HI,

try this Expression for Branches that do not have Document 2

= count(DISTINCT aggr(count(DISTINCT if(document<>'document2', branch)),branch))

Please find the attachment

Highlighted
Partner
Partner

Ha, that's not what you asked for though