Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Distinct Count

hI,

Create straight/Pivot table

Take

ALT_ACTION_USRID as Dimension

and

Count(Distinct mar) as expression

Regards

Regards,
Prashant Sangle

Re: Distinct Count

Create straight table

Dimension : ALT_ACTN_USER_ID

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

Not applicable

Re: Distinct Count

Straight table

     Dimension -> ALT_ACTN_USER_ID

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

Regards,

KKR

manojkulkarni
Valued Contributor II

Re: Distinct Count

Take

ALT_ACTION_USRID as Dimension

and

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

qlikmsg4u
Valued Contributor

Re: Distinct Count

Hi Senthil

Please find the attached app

Not applicable

Re: Distinct Count

Hi

The output was not correct.

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

sasiparupudi1
Honored Contributor III

Re: Distinct Count

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

rohit18492
New Contributor III

Re: Distinct Count

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

Community Browser