Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Layout.jpg

Labels (1)
1 Reply
Highlighted
Partner
Partner

Re: Net Sales vs Target Sales

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])

 

Regards,

Mohamed