topic Re: Delete row in QlikView

Delete row

Anonymous — Tue, 20 Feb 2018 07:50:22 GMT

Hello Guys,

I am facing one issue, where record number was created for two companies on same date, The expression should be include latest record in the report .I marked in the color red for the required record in the attached screen capture. Please check it and suggest me.

Regards,

Krishna

Re: Delete row

jaumecf23 — Tue, 20 Feb 2018 08:36:31 GMT

In the affected expression, set the total mode as it says the screenshot :

Re: Delete row

Anonymous — Wed, 21 Feb 2018 08:16:01 GMT

Hello Jaume,

The final value will be expression total because the value should match to KPI value, Anyway still same result after selecting your suggested option. Need a condition which excludes if same record found in two places.

Regards,

Krishna

Re: Delete row

jaumecf23 — Wed, 21 Feb 2018 11:04:25 GMT

Maybe you can use the Dimensionality() function and do an expression formula for the total expression

Re: Delete row

Anonymous — Wed, 21 Feb 2018 11:06:34 GMT

Hello Jaume,

Can you provide me one example of Dimensionality() function ,please

Regards,

Krishna

Re: Delete row

jaumecf23 — Wed, 21 Feb 2018 13:25:36 GMT

Something like this :

if(Dimensionality()=0, expression for total, actual expression)