Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
rajender_qlik
Creator
Creator

How to delete the selected row in a straight table using a button

Hi everyone,

I have a straight table which is used for comments. Where the user can input the comments using input and that will be stored in a straight table based on time stamp, username and comment. So if i need to delete the selected row in straight table using button how Can I achieve it ?

I just need to select time stamp in the straight table and if i click delete only that row in the table should be deleted.

Thanks for any suggestions / help.

16 Replies
Anil_Babu_Samineni

I am not understanding any thing. Does it related to Buttons deleted on what bases? Can you help us to ravine the data to get better understand

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
rajender_qlik
Creator
Creator
Author

I have a straight table chart with data like this.

TimeStamp User Comment
05/22/2017 10:08:12rputtahello
05/22/2017 10:08:39rputtahey
05/22/2017 10:08:54rputtathis is a sample msg
05/22/2017 10:09:03rputtatest msg
05/22/2017 10:17:20rputtaHi test msg for deletion
05/22/2017 11:11:38rputtahey

So If i select last row in the table and click the delete button then selected row should be deleted from table.

result should be like this.

TimeStampUserComment
05/22/2017 10:08:12rputtahello
05/22/2017 10:08:39rputtahey
05/22/2017 10:08:54rputtathis is a sample msg
05/22/2017 10:09:03rputtatest msg
05/22/2017 10:17:20rputtaHi test msg for deletion

How can i achieve this using variables or macro ? guide me.

Anonymous
Not applicable

I think this makes no sense, you can't delete anything at all.

But you can select the excluded selection for example like that:

LOAD * INLINE [
A, B, C, D
1, 2, 3, 4
5, 6, 7, 8
9, 1, 2, 3
4, 5, 6, 7
12, 4, 6, 9
]
;

expression: 

only({1-$} D)

Anil_Babu_Samineni

May be look this? And don't worry about User and Comment. Open the document and notice whether is there any change when we hit Button. May e helpful to you

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
rajender_qlik
Creator
Creator
Author

Thanks for your reply Anil Babu.

But that doesn't solve my issue.

rajender_qlik
Creator
Creator
Author

Thanks for your reply Robin.

Its only for show/hide the data. But I want to completely delete the selected row in straight table.

Anonymous
Not applicable

I still don't understand what you mean by delete ?!?

rajender_qlik
Creator
Creator
Author

I mean completely removing data row from the straight table chart.

Anonymous
Not applicable

You mean after pressing the delete button you'll have no chance to get the deleted lines back?