topic Re: Filtering data from a table in QlikView

Filtering data from a table

Fri, 10 Feb 2012 18:12:36 GMT

Hi, i have just got QlikView and i am just beginning to create reports.

I have a very simple question.

I have uploaded a spreadsheet into QlikView, about 65000 rows.

Now in one of my charts i want to only show packed product, this is shown in a field 'IsaPrePack' as 1. The only other value in the field is 0

How do i show only the data that has a 1 in IsaPrePack? I have tried expression 'Isaprepack =1' but this still returns all rows..

Sorry for being slow but i cannot seem to get my head round this!!

Thanks

Filtering data from a table

Anonymous — Fri, 10 Feb 2012 18:40:38 GMT

What you could do in your load script is a line like:

Load ..

From ..

Where IsaPrePack =1 ;

Or add a selection field IsaPrePack and just select (and lock) 1

Re: Filtering data from a table

Anonymous — Sat, 11 Feb 2012 06:24:33 GMT

Hi Kevin

In qlikview ew can remove the unwanted data using the set analysis in chart/table itself.

I believe the attached qlikview file will be solve your problem.

Regards,

Ashok

Filtering data from a table

Jason_Michaelides — Sat, 11 Feb 2012 07:24:44 GMT

Or add a calculated dimension:

=IF(IsaPrePack=1,Product)

Hope this helps,

Jason

Filtering data from a table

jagan — Sat, 11 Feb 2012 08:07:41 GMT

Hi,

In qlikview you can filter the data by using expressions.

Example:

=Sum({<IsaPrePack={1}>} Sales)

Returns the sum of Sales whose IsPrePack is 1.

Likewise you can use the set analysis to filter the results.

Regards,

Jagan.

Re: Filtering data from a table

Thu, 17 Oct 2013 12:28:16 GMT

Hi Kevin

I would be delighted to speak regarding a number of the questions you have posted in the past weeks, as appropriate introducing you too our Head Of QlikView Practice, in addition to discussing a wider programme we are engaged upon with your UK business that may prove invaluable.

Please see my contact details below as appropriate.

Kindest Regards

James Adams | Head of Lead Generation

Mobile: 07500084576 | email: james.adams@dbg.co.uk

New London Office, dbg, 5^th Floor, 35-38 New Bridge St, London, EC4V 6BW

Re: Filtering data from a table

Fri, 25 Nov 2016 15:35:54 GMT

It helped me.

Thanks