Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm trying to have a filter with the variable i have created.
Variable: ActualDeliveredQty = (sum(aggr(sum(DISTINCT [Delivery Qty]),[Sales Order],[Sales Order Item No.])))
And what I am trying to do is to create a dimension named MATCH DATA where
MATCH DATA = if([Order Qty]=$(ActualDeliveredQty),'Matched', 'Unmatched')
My goal is to filter my data by 'Matched' and 'Unmatched'
Unfortunately, even though this formula works, when I include the dimension in my table, it became "Invalid Dimension"
How can I achieve this? Please help. Thank you.
Hi @Kush thanks for this, but it looks like the data became inaccurate.
some rows which are actually matched became unmatched and vise versa. Tried also to filter but i got an error says 'invalid command'..
@Kush yes i added it as calculated dimension named as Match Data column,
while Order = Actual Delivered Qty column is a calculated measure
(if([Order Qty]=$(ActualDeliveredQty),'Matched', 'Unmatched')
which serve as my basis if data based on the provided formula above are correct