topic Re: Hi Friends how to do sum of two rows as a single in QlikView

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

Tue, 27 Jan 2015 17:49:47 GMT

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)

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

sunny_talwar — Tue, 27 Jan 2015 17:58:12 GMT

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,

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

chrismarlow — Tue, 27 Jan 2015 19:20:06 GMT

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

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

engishfaque — Wed, 28 Jan 2015 05:01:10 GMT

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