Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

set analysis

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

10 Replies
arulsettu
Master III
Master III

may be this

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

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

Not applicable

='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
Creator III
Creator III
Author

Sorry Arul it results Total number of applications

arulsettu
Master III
Master III

check above else post sample app

jagan
Partner - Champion III
Partner - Champion III

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
Luminary
Luminary

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

Not applicable

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
Not applicable

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
Master
Master

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


HirisH
“Aspire to Inspire before we Expire!”