Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

straight table

Hi Team

I have a straight table which is having 25 rows

can we delete certain rows in the straight table, how can we do

regards

Pnreddy

16 Replies
Not applicable
Author

Thank You

Not applicable
Author

Thank You

its_anandrjs
Champion III
Champion III

Updated now check

Write dimension like

If( Not Match(A,'a4'),A) in the dimension



and select Suppress when value is Null

Anonymous
Not applicable
Author

Like everyone else says, do it by

- not loading it in the data in the first place (where clauses, match(), if() and so on)

- by making an expression in the straight table resulting in the row(s) not being displayed

- by doing selections in the straight table.

I think the best solution for you depends on WHY you want to delete/hide the row(s), cause I'm not fully understanding your requirement. Should it be present in the data at all, is it during navigation/analysis you want to disregard the row etc.

/Nicolai

Not applicable
Author

i have one more question

can we foramat the straight table as below

Capture.PNG.png

MK_QSL
MVP
MVP

Go to style tab and select from Current Style

Anonymous
Not applicable
Author

Hi

What formatting are you looking for specifically?

- the bold headers

- the separated "$            105" values

- the conditional coloring of the rows

- no row borders?

Remember besides style, you get more options for formatting when design grid is activated, e.g. custom format cell when right clicking the cells.