topic Re: Using GetpossibleCount with Set analysis in QlikView

Using GetpossibleCount with Set analysis

Sun, 17 Feb 2013 05:26:07 GMT

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

Re: Using GetpossibleCount with Set analysis

swuehl — Sun, 17 Feb 2013 12:15:04 GMT

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

Re: Using GetpossibleCount with Set analysis

Mon, 18 Feb 2013 07:29:56 GMT

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