topic Re: Set analysis in QlikView

Set analysis

nareshthavidishetty — Wed, 13 Jan 2016 19:50:39 GMT

I have a field Application status which defines Approved,Declined and processed and application count

May i know how to write an set analysis to get number of applications Approved,Declined and processed.

sunny_talwar — Wed, 13 Jan 2016 19:53:36 GMT

May be this:

Dimension: Applications

Expression: Count({<[Application Status] = {'Approved', 'Declined', 'Processed'}>} Applications)

engishfaque — Thu, 14 Jan 2016 03:26:50 GMT

Dear Naresh,

Here are the expressions,

Expression 1 : Count Approved Application

Count({<[Application status] = {'Approved'}>} applications)

Expression 2 : Count Declined Application

Count({<[Application status] = {'Declined'}>} applications)

Expression 3 : Count Processed Application

Count({<[Application status] = {'Processed'}>} applications)

Kind regards,

Ishfaque Ahmed

jagan — Thu, 14 Jan 2016 03:45:26 GMT

HI,

Try like this

Dimension: Applications

Expression: Count(Applications)

Or if you want to calculate it individually then use below expressions

Approved Applications Expression: Count({<[Application Status] = {'Approved'}>} Applications)

Declined Applications Expression: Count({<[Application Status] = {'Declined'}>} Applications)

Processed Applications Expression: Count({<[Application Status] = {'Processed'}>} Applications)

Hope this helps you.

Regards,

Jagan.