Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-08-24 08:48 AM

How can you include all rows of a group if any match a user defined selection?

Hey everyone,

I'm trying to create a chart that will eliminate zero values based on a user's year selection.

chart.PNG

I am trying to make it so that if, for example, a user picked Year 2022, then only project C would show. However, project C should still show data in all other columns.

Basically, I would like to remove zero investment values from any column the user selects without removing the projects overall investment forecast. The data is currently formatted as below.

data.PNG

I've tried using group by in the script to create flags, aggr calculated dimensions, and several other options, however I seem to only be able to display all data for a given column if I zero out the other columns. Do any of you have any suggestions?

Thank you

341 Views
0 Likes
0 Replies