Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Net Sales vs Target Sales

Hi i have a qvw which i intend to bring in my target sales which maintain in a excel sheet. 

But when i map it, the target sales is appear at each of the field which i only need it to be place at the last column. Please assist on this. 

Thank You


Labels (1)
1 Reply
Partner - Contributor III
Partner - Contributor III

If Target Sales is a distinct field remove "Target Sales" from the table's dimensions and keep the measure calculating the target sales.


If you loaded "Target Sales" Concatenated with the "Sales Amounts" use a flag to distinguish rows of Target Sales, and display only the "Sales Amounts"

If(SalesFlag = "Sales Amounts", [Sales Amounts])