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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Subba55
Contributor III
Contributor III

How to calculate percentage ?

Hi Guys,

i want to show percentages

data like

Input:

Data  Q1 2021   %

A        170               ?

B       291              ?

C      19              ?

Total  480     100%

Output:

Data  Q1 2021   %

A        170               35.4%

B       291             60.6%

C      19        4%

Total  480     100%

How to write Expressions.

Please help me,

Thanks in advance

Regards,

Subba

3 Replies
Taoufiq_Zarra

@Subba55 

=sum(Q12021)/sum(total Q12021)

and change number format to %

output

Taoufiq_Zarra_0-1623069258748.png

 

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Subba55
Contributor III
Contributor III
Author

Q1 2021 means i have writen this Expression

Count( distinct{<Date_Material={">=$(vLastQuarterStart)<=$(vLastQuarterEnd)"}>}requestid)

Subba55
Contributor III
Contributor III
Author

Hi Taoufiq ZARRA,

i want to show only jan 2021 data using set analysis,

Exe: count(requestid)
i have used this exp:

count({<Year={'vCurrentyear'},month={'vcurrentmonth'},milestone={'On'}>}requestid)

But not working..

please help me this.

 

Regards,

Subba