topic Creating Filters/Grouping in QlikView

Creating Filters/Grouping

Anonymous — Tue, 13 Jan 2015 19:11:47 GMT

Hi all,

So I am trying to figure out how I can filter certain values in my data.

For Example:

I am building an app for a clothing distribution company. I have a dimension of 'Shirts' with different values based on the type and color - short sleeve, long sleeve, tank, blue, black, red, white.

I want to filter out the colors and sleeve type but they aren't their own dimension - just data inside of the field 'Shirts'. What can I do to filter these out and make charts/tables for them.

Thanks so much

Re: Creating Filters/Grouping

agomes1971 — Tue, 13 Jan 2015 19:32:01 GMT

Hi,

in your data model you must have a field called shirts with the values short, long, tank and a field called color with the values blue, black, red & white.

Regards

André Gomes

Re: Creating Filters/Grouping

maxgro — Tue, 13 Jan 2015 19:37:30 GMT

if you post the distinct values of your Shirts dimension we can try to split the field as Andre Gomes suggested