Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
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