Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ketanvaria
Contributor III
Contributor III

Delete row from table

I have a table here (with sample  data) where the last two is just a sum of the all the months. I don't want to see this in the sheets and analysis. I know how to hid a column from analysis but how do you hide a row from analysis?

15 Replies
ketanvaria
Contributor III
Contributor III
Author

Screen Shot 2018-10-02 at 17.15.35.pngScreen Shot 2018-10-02 at 17.16.01.png

ketanvaria
Contributor III
Contributor III
Author

see my further point below - for A KPI

achakilam1022
Creator II
Creator II

May be

sum({<Date-={}>}ConsultancyIncome(2))

nsetty
Partner - Creator II
Partner - Creator II

Try excluding the records while loading itself.

[Sheet1]:

LOAD

Date([Date] ) AS [Date],

[Income],

[Consultancy Income (2)],

[Product Income (3)],

[Interest earned]

FROM [lib://qlikid_ketanvaria/cross_Table_Sample.xlsx]

(ooxml, embedded labels, table is Sheet1)

WHERE Len(Date)<>0;

Add

WHERE Len(Date)<>0;

agigliotti
Partner - Champion
Partner - Champion

you can use the expression below:

SUM( {< Date = {"*"} >} [Consultancy Income (2)] )


I hope it helps.

agigliotti
Partner - Champion
Partner - Champion

Please mark the answers as Helpful / Correct if applicable to help others cummunity members.

Thanks.