Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using GetpossibleCount with Set analysis

Hi,

I want to get the possible count of QV license used by the users from the log file. For that if i use,

 

GetPossibleCount(

[Cal Type] ) is working but

if i use

 

GetPossibleCount

({<[Cal Type] = {'Document'} >}[Cal Type]

)

to get only the Cal Tye license it not working.

Any idea

Thanks,

Selva

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Please check the HELP for GetPossibleCount() function, which doesn't accept a set expression.

Try maybe

=count(DISTINCT {<[Cal Type] = {'Document'} >} [Cal Type])

which might return only 0 or 1.

Probably I don't get what you want do, so maybe just attach a small sample app with your data and describe your expected outcome.

Regards,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

Please check the HELP for GetPossibleCount() function, which doesn't accept a set expression.

Try maybe

=count(DISTINCT {<[Cal Type] = {'Document'} >} [Cal Type])

which might return only 0 or 1.

Probably I don't get what you want do, so maybe just attach a small sample app with your data and describe your expected outcome.

Regards,

Stefan

Not applicable
Author

Hi Swuel,

That's right, it will not accept the set expression.

In my application what i want to calculate is the count of unique users using the QV application at a time (Document Cal wise, Name Cal wise) using the QV Session data log available in server.

Thanks,

Selva