Hi Friends how to do sum of two rows as a single

[#1]

Hi Friends Need help in adding below two rows into single row . In excel we have Group (sum of N/A and (blank) rows) value and we need to have the same format in qlikview . Can you please help on how can we show only Group in qlikview (sum of two rows (N/A and (blank))) .

In QlikView is there any way to combine N/A and - rows as Single row value

=if(QIik like ('N/A'),'Group1',QIik)

=if(QIik like ('N/A') or '-','Group1',QIik)

[sunny_talwar]

You can use RangeSum to add two columns in script. I don't really understand the if conditions you have here, but if you have a sample data I can probably create a sample qvw file for you to view.

Best,

S

[chrismarlow]

Are your dashes in fact nulls? So (including them being dashes) if(Qlik='-' Or IsNull(Qlik),'Group1',Qlik)? (presuming left column is Qlik dimension).

[engishfaque]

Dear Srikanth,

I hope, you are looking for this.

=Sum (Alt(Group1, '-', 0)) + Sum (Alt(NA, '-', 0))

This expression set value "0" when it finds "-".

Kindly find attached "AddDashValues.qvw" for clear understanding.

Kind regards,

Ishfaque Ahmed