Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
Is it possible to show remark on chart?
Attached qvf and excel.
for example:
when i filter
01/01/2017, location L1, show Public Holiday
21/01/2017, Location L1 show Raining
So, when I'm selecting L1 Location then my quantity will be 0 means Only L1 bar will be there with 0 quantity and Remark will be Public holiday and Raining...Is it like that?
Just color by dimension 'remark':
Thanks, manage to do it
SET vCurrentDate= =Date(Max([Date]),'DD/MM/YYYY');
Quantity Expression
Sum({<[Date]={'$(vCurrentDate)'} >}Quantity)
Remark Expression
Text(only({<Date={"$(=vCurrentDate)"}>} Remark))