topic Re: Exclude rows in QlikView

Exclude rows

Wed, 25 Nov 2020 16:16:04 GMT

I have an umber of orders that have a different statuses- closed, cancelled, completed, authorise etc.

I always want to exclude the cancelled ones. I know this can be done using a list box and choosing the statuses I want to see. Is there anyway this can be a bit more dynamic

Re: Exclude rows

mightyqlikers — Thu, 21 Jul 2016 10:22:33 GMT

hi david,

you can do in script level to restrict the data .

load * from tbl

where Status <> 'Cancelled';

$@M.

Re: Exclude rows

Thu, 21 Jul 2016 10:24:14 GMT

Hi Dave,

You can simply select the required values from your list box and then 'right click' on the list box and select 'lock'.

This will ensure the fields will not be changed even if you clear all your selections. To go back to the previous state, 'right click' on the list box and select 'unlock'.

Hope it helps.

Regards,

Sakir

Re: Exclude rows

susovan — Thu, 21 Jul 2016 10:25:50 GMT

Hi Dave,

You can also use the 'Dimension Limits' option to restrict your dimension.

Re: Exclude rows

sunny_talwar — Thu, 21 Jul 2016 10:25:51 GMT

You can exclude them in the script or you can assign a flag to all those statuses that you don't want to see and create a button on the front end to hide those statuses by selecting the showFlag.

Re: Exclude rows

Anonymous — Thu, 21 Jul 2016 10:33:11 GMT

Hi David

In the script create a flag as Sunny suggested something like

Load *,

if(Status<>'Cancelled','Y','N')as Include_Status_Flag

from you data source

then in chart expression sum({<[Include_Status_Flag]={'Y'}>Value)