Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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
Or add a calculated dimension:
=IF(IsaPrePack=1,Product)
Hope this helps,
Jason
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.
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, 5th Floor, 35-38 New Bridge St, London, EC4V 6BW
It helped me.
Thanks