Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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
Partner

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