Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Calculated Dimension

I am attempting to create a table using the following field.

promoCDE which has values such as 'Adult' 'MACBAN' 'FSTBRK'

I wan to build a table that has these different types of 'promoCDE' as the dimensions and then use the field =[Net Sold Qty] as the expression. My output would be:

promoCDE          [Net Sold Qty]

Adult                         #,###

MACBAN                    #,###

FSTBRK                    #,###

1 Solution

Accepted Solutions
sunny_talwar

May be use set analysis instead

Dimension

promoCDE

Expression

Sum({<promoCDE = {'Adult', 'MACBAN', 'FSTBRK'}>}[Net Sold Qty])

View solution in original post

1 Reply
sunny_talwar

May be use set analysis instead

Dimension

promoCDE

Expression

Sum({<promoCDE = {'Adult', 'MACBAN', 'FSTBRK'}>}[Net Sold Qty])