topic Re: set analysis in QlikView

set analysis

nareshthavidishetty — Tue, 19 Jan 2016 08:30:32 GMT

I have application number and application source= Retail and Web, here i need to show number of retail applications and number of web applications

Re: set analysis

arulsettu — Tue, 19 Jan 2016 08:33:42 GMT

may be this

count({<application source= {'Retail'}>}[application number])

count({<application source= {'Web'}>}[application number])

Re: set analysis

Tue, 19 Jan 2016 08:38:28 GMT

='No of Retail application '&count({<[application source]= {'Retail'}>}[application number])&' and No of web application '&'Count of Retail application '&count({<[application source]= {'Web'}>}[application number])

Show it in a Text Object

Re: set analysis

nareshthavidishetty — Tue, 19 Jan 2016 08:40:07 GMT

Sorry Arul it results Total number of applications

Re: set analysis

arulsettu — Tue, 19 Jan 2016 08:41:21 GMT

check above else post sample app

Re: set analysis

jagan — Tue, 19 Jan 2016 08:46:58 GMT

Hi Naresh,

Attach some sample data and your expected output so that it would be easier to understand and provide the solution.

Regards,

jagan.

Re: set analysis

Mark_Little — Tue, 19 Jan 2016 08:50:58 GMT

HI,

I would say Arul is correct, like he suggested some demo data would be helpful.

All i can add is maybe use distinct.

Count({<application source = {'Web'}>}Distinct [Application Number])

Mark

Re: set analysis

Tue, 19 Jan 2016 08:59:00 GMT

Hi Naresh,

Try like this:

Expressions:

Retail Applications Expression : Count({<[application source]= {'Retail'}>}[application number])

Web Applications Expression : Count({<application source= {'Web'}>}[application number])

I hope it will useful for you.

Thanks

Divya

Re: set analysis

Anonymous — Tue, 19 Jan 2016 09:07:51 GMT

Hi Naresh,

use below syntax if Application Number is not unique

count({<application source = {'Retail'}>}Distinct [application number])

count({<application source = {'Web'}>}Distinct [application number])

else

count({<application source= {'Retail'}>}[application number])

count({<application source= {'Web'}>}[application number])

if the above is not what you are looking for,please be more specific of your requirement.

Regards

Neetha

Re: set analysis

HirisH_V7 — Tue, 19 Jan 2016 09:33:50 GMT

Hi,

this is another way ,

IF([application source ]= 'Retail',Count( [application number]))
IF([application source ]= 'Web',Count( [application number]))

Then keep totals mode for expression as Sum of rows,

HTH,

Hirish

Re: set analysis

PradeepReddy — Tue, 19 Jan 2016 09:52:35 GMT

in bar chart, try like this..

dimension : "application source"

expression : Count(application number)