Discussion board where members can get started with QlikView.
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.
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])