topic Re: Re: Filtered data table in QlikView

Filtered data table

hobanwashburne — Fri, 22 Aug 2014 18:37:50 GMT

I have a data set consisting of Order Type, Order Number, Release, Customer Name, Part Number, Quantity, and Requested Ship Date. The possible values for Order Type are A, B, and C. I want to create a table that only shows the data for order type B and I do not need to calculate anything - Just display the relevant data.

Re: Filtered data table

ashfaq_haseeb — Fri, 22 Aug 2014 18:42:06 GMT

Hi,

Try below

Load

[Order Type],

[Order Number],

Release,

[Customer Name],

[Part Number],

Quantity;

sql select * From table

where [Order Type] ='B'

Regards

ASHFAQ

Re: Filtered data table

hobanwashburne — Fri, 22 Aug 2014 19:03:21 GMT

I need the complete data set for other charts, but for one specific table I only want to display a specific order type.

Re: Filtered data table

Anonymous — Fri, 22 Aug 2014 19:38:31 GMT

you probably are referring to set analysis...something like sum({<[Order Type] = {"B"}> Quantity)...but you may want to elaborate more on your requirement and what your expected output looks like and if this output is in a chart/table, etc.

Re: Re: Filtered data table

hobanwashburne — Fri, 22 Aug 2014 20:02:36 GMT

Please see attached

Re: Re: Re: Filtered data table

Anonymous — Fri, 22 Aug 2014 20:10:33 GMT

see attached and modify as needed.