Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ketanvaria
New Contributor III

Re: Delete row from table

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

Highlighted
ketanvaria
New Contributor III

Re: Delete row from table

see my further point below - for A KPI

achakilam1022
Contributor II

Re: Delete row from table

May be

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

Partner
Partner

Re: Delete row from table

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;

Partner
Partner

Re: Delete row from table

you can use the expression below:

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


I hope it helps.

Partner
Partner

Re: Delete row from table

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

Thanks.