Filtering data from a table

[#1]

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

[Anonymous]

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

[Anonymous]

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

[Jason_Michaelides]

Or add a calculated dimension:

=IF(IsaPrePack=1,Product)

Hope this helps,

Jason

[jagan · Accepted solution]

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.

[#6]

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

[#7]

It helped me.

Thanks