Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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])