topic Re: set expression in QlikView

set expression

Wed, 27 Jun 2012 10:59:46 GMT

i have a table

Event Id

Date

121

4/27/2012

122

4/27/2012

123

4/25/2012

i need to count event ids with unique Date, in the above example it should return 2

lironbaram — Wed, 27 Jun 2012 11:04:32 GMT

hi try

count(distinct Date)

Wed, 27 Jun 2012 11:06:27 GMT

that would return desired count but i want to count eventids due to other limitations

i have a table

Event Id

event name

Date

121

abc

4/27/2012

122

abc

4/27/2012

123

abc

4/25/2012

124

xyz

4/25/2012

in this table event 'abc' occured twice and 'xyz' occured once , so now the expression should return count of events 3

lironbaram — Wed, 27 Jun 2012 11:12:16 GMT

so you can add

count(distinct Date&[event name])

basicly i would prefer not using set analysis in my expressions

try to keep it as simple as possible

somenathroy — Wed, 27 Jun 2012 11:12:32 GMT

This is snap of a straight table.