Net Sales vs Target Sales

prabunakil — Sat, 16 Nov 2024 20:41:55 GMT

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

Re: Net Sales vs Target Sales

lazurens — Fri, 14 Jun 2019 13:25:52 GMT

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

topic Net Sales vs Target Sales in QlikView

Net Sales vs Target Sales

Re: Net Sales vs Target Sales