set analysis

[nareshthavidishetty]

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

[arulsettu]

may be this

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

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

[#3]

='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

[nareshthavidishetty]

Sorry Arul it results Total number of applications

[arulsettu]

check above else post sample app

[jagan]

Hi Naresh,

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

Regards,

jagan.

[Mark_Little]

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

[#8]

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

[Anonymous]

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

[HirisH_V7]

Hi,

this is another way ,

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

Then keep totals mode for expression as Sum of rows,

HTH,

Hirish