topic Re: Problem Whit Grouping QV11 in QlikView

Problem Whit Grouping QV11

ester_pr — Sun, 24 Jun 2012 11:45:24 GMT

Hi All,

I Have a problem whit Grouping Set Analysis

for example :

sum

({[Group 1]<Region = $::Region, [Sales Rep] = $::[Sales Rep]>} Sales)

If I am looking at Part Dimension and ther is a Part that have no Region the values will show 0

How will i make the object consider Region selection without Deletion data?

swuehl — Sun, 24 Jun 2012 13:53:30 GMT

ester_pr,

not sure if I understand your issue, is it a problem with grouping in a chart or with alternate states / set expression?

I think it would help if you could post a small sample qvw file here or describe your data model a bit more detailed.

Regards,

Stefan

ester_pr — Mon, 25 Jun 2012 09:10:58 GMT

Stefan thanks,

As you can see ,

there are 2 columns,

1 column is a simple sum

the other column a sum that allows reference to list box of code filed

when ever code is null to snif as in kvj the value becomes 0

Regards,

Ester

ester_pr — Mon, 25 Jun 2012 09:11:10 GMT

Stefan thanks,

As you can see ,

there are 2 columns,

1 column is a simple sum

the other column a sum that allows reference to list box of code filed

when ever code is null to snif as in kvj the value becomes 0

Regards,

Ester