Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ester_pr
New Contributor

Problem Whit Grouping QV11

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?

3 Replies
MVP
MVP

Re: Problem Whit Grouping QV11

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
New Contributor

Re: Problem Whit Grouping QV11

Stefan thanks,

As you can see ,

there are 2 columns,test.JPG

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
New Contributor

Re: Problem Whit Grouping QV11

Stefan thanks,

As you can see ,

there are 2 columns,test.JPG

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

Community Browser