Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage calculation with null Dimension values.

Hi

how to get the total with out null values...

Column1 Column2

Sale         20

Share       10

Rev          40

-              10

I need to calculated the percentage not with the column1 having '-' .

%Column 3= Sum(Column2) / Sum(total Column2) which will be

Also I have selected "Supress when value is Null" option  and it is providing me the below result

Column1 Column2 column3

Sale         20            20/100

Share       10            10/100

Rev          40             40/100

But i need to display the chart as below and how can i get it in expressions but not changing in the script.

Column1 Column2 column3

Sale         20            20/90

Share       10            10/90

Rev          40             40/90

Thanks

RK

1 Reply
CELAMBARASAN
Partner - Champion
Partner - Champion

Try with this

%Column 3= Sum(Column2) / Sum({<Column1={"=not IsNull(Column1)"}>} total Column2)

or

%Column 3= Sum(Column2) / Sum({<Column1={"*"}>} total Column2)

Hope it helps

Celambarasan