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

Distinct Count

ACT_DATEMARALT_ACTN_USER_ID
2-Jun-15150529SCBLMYKXBLAB08641921341487822
2-Jun-15150529SCBLMYKXBLAB08641921341487822
2-Jun-15150529SCBLMYKXBLAB08641921341487822
2-Jun-15150529SCBLMYKXBLAB08641921341487822
2-Jun-15150529SCBLMYKXBLAB08641921341487822
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487821
3-Jun-15150603SCBLMYKXALAB01298752131487823
3-Jun-15150603SCBLMYKXALAB01298752131487823
3-Jun-15150603SCBLMYKXALAB01298752131487823
3-Jun-15150603SCBLMYKXALAB01298752131487823
3-Jun-15150603SCBLMYKXALAB01298752131487823
3-Jun-15150603SCBLMYKXALAB01298752131487823
3-Jun-15150603SCBLMYKXBLAB08651988471487823
4-Jun-15150604SCBLMYKXXLAB04037026551487823
4-Jun-15150604SCBLMYKXALAB01298769381487823
4-Jun-15150604SCBLMYKXALAB01298769381487823
4-Jun-15150604SCBLMYKXALAB01298769381487823
2-Jun-15150529SCBLMYKXBLAB086419213551487822
2-Jun-15150529SCBLMYKXBLAB086419213551487822
2-Jun-15150529SCBLMYKXBLAB086419213551487822
2-Jun-15150529SCBLMYKXBLAB086419213551487822
2-Jun-15150529SCBLMYKXBLAB086419213551487822
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-15150529SCBLMYKXBLAB0864191487821
3-Jun-151AB086419213551487823
3-Jun-151AB086419213551487823
3-Jun-151AB086419213551487823
3-Jun-151AB086419213551487823
3-Jun-151AB086419213551487823
3-Jun-151AB086419213551487823
3-Jun-151AB086419213551487823
4-Jun-151AB086419213551487823
4-Jun-151AB086419213551487823
4-Jun-151AB086419213551487823
4-Jun-151AB086419213551487823

In the above table    ,

Need to find for given ALT_ACTION_USRID , count of Unique mar greater than 2

8 Replies
PrashantSangle

hI,

Create straight/Pivot table

Take

ALT_ACTION_USRID as Dimension

and

Count(Distinct mar) as expression

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Kushal_Chawda

Create straight table

Dimension : ALT_ACTN_USER_ID

Expression :count({<MAR= {"=count(MAR)>2"}>}MAR)

Not applicable
Author

Straight table

     Dimension -> ALT_ACTN_USER_ID

     Expression -> If(Count(DISTINCT MAR)>2,Count(DISTINCT MAR))

Regards,

KKR

manojkulkarni
Partner - Specialist II
Partner - Specialist II

Take

ALT_ACTION_USRID as Dimension

and

Expression would be --count(distinct if(aggr(count(MAR),ALT_ACTN_USER_ID,MAR)>2,MAR))

qlikmsg4u
Specialist
Specialist

Hi Senthil

Please find the attached app

Not applicable
Author

Hi

The output was not correct.

Requirement is No of Days , where the COunt(DISTINCT MAR) > 2

sasiparupudi1
Master III
Master III

What do you mean by no of days? count of the act_date? it would be helpful if you could post some sample document or  a more detailed requirement

_rohitgharat
Creator
Creator

Hi senthil,

              First of all make sure what is your requirement and what you want to display. 'No of Days , where the Count(DISTINCT MAR) > 2' doesn't make any sense or may be it seems clueless. I think requirement may be to calculate count (MAR) pending since no. of days.

Thanks,

Rohit