Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sth_wch004
New 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
Contributor II

Re: Qlik Sense - show remark on chart

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
Esteemed Contributor

Re: Qlik Sense - show remark on chart

Just color by dimension 'remark':

Capture.PNG

sth_wch004
New Contributor III

Re: Qlik Sense - show remark on chart

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

Community Browser