Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sth_wch004
Contributor III
Contributor III

Qlik Sense - show remark on chart

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

2.JPG


1.JPG




3 Replies
md_qlikview
Creator II
Creator II

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?

OmarBenSalem

Just color by dimension 'remark':

Capture.PNG

sth_wch004
Contributor III
Contributor III
Author

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))