Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number of units chart information

Hi Guys,

I wonder if anyone could help me I have a chart displaying number of units and then the dimensions set as packaging type.

what I would like to do is create another chart with units and display only 3 off the packaging types

I tried creating a inline load from the packaging to a newgroup where ive specified what packaging I wish to display. but this shows all the same totals in the chart which I know is incorrect

could someone please advise the best way of achieving this?

Thanks

Jason

3 Replies
Not applicable
Author

You could create a calculated dimension in the chart


=if(Packaging_Type = 'A' or Packaging_Type = 'B' or Packaging_Type = 'C',packaging_product)


make sure to check the box "supress Value when null"

Not applicable
Author

Hi Carney

when i do that it doesnt total them and display them as the package type? maybe im just doing something wrong 😉

Not applicable
Author

Can you upload the qvm file. See instructions attached!