Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Need To Do A Rollup Sum For Certain Rows and Sum All Others

 

Hello:

 

 

 

First, I believe I'm making this harder than it needs to be and my apologies for the length of the post.           But I've been looking at it too long and I would appreciate another set of eyes taking a look.  I currently have the following output from this expression:

 

Expression:

 

 

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Hi Perry
Some possible solutions could be to

  • create a new column in your XLS which identifies the parent grouping
  • create a mapping table in your load script that effectively does the above, but in script
  • or possibly the easier is to use Calculated Dimension in your chart eg.

=IF(Wildmatch(ProductField,'NAS*'),'NAS (GB)',

IF(Wildmatch(ProductField,'SAN*'),'SAN (GB)',

ProductField)

Hope that helps
Duncan

View solution in original post

2 Replies
Highlighted
Creator
Creator

Hi Perry
Some possible solutions could be to

  • create a new column in your XLS which identifies the parent grouping
  • create a mapping table in your load script that effectively does the above, but in script
  • or possibly the easier is to use Calculated Dimension in your chart eg.

=IF(Wildmatch(ProductField,'NAS*'),'NAS (GB)',

IF(Wildmatch(ProductField,'SAN*'),'SAN (GB)',

ProductField)

Hope that helps
Duncan

View solution in original post

Highlighted
Partner
Partner

Hello Duncan:

 

Sorry for the delay in replying.  Thank you for your response.  Your suggestion of using Wildmatch did the trick.  Thank you very much for that.  Turns out I needed to roll up a couple more items.

 

 

Thanks again.  I'll mark your response as the correct answer.