Solved: delete complete row in straight table - Qlik Community

Anonymous · ‎2015-07-15

could someone please help me to delete complete row in straight table. I'm able to hide that particular row but not delete, when i hide this its still summing up in grand totals which I dont want.

please find attached qvw,

PrashantSangle · ‎2015-07-15

Hi,

USe below expression for Sales,

=if(Column(1)>0 or Column(2)>0,sum(10))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2015-07-15

Hi,

USe below expression for Sales,

=if(Column(1)>0 or Column(2)>0,sum(10))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous · ‎2015-07-15

thanx Max,

Report Inappropriate Content · ‎2016-03-17

I have the similar issue, could you please share this qvw?