Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Wanted to add comments in the chart

Hi Experts,

   I wanted to show comments when user hovers on that, as per the chart depicts
  For example PFA. in the below chart Aug is having highest value. when we hover on that it has to dispaly the comment as 'High'

in the same way i need to display comments as per chart changes(i.e, dynamically)

Thankz in advance

8 Replies
maleksafa
Valued Contributor

Re: Wanted to add comments in the chart

create the expression that rank the sales from highest to lowest, and then in the expression tab under display options uncheck everything and check the 'Text as pop-up' option.

Not applicable

Re: Wanted to add comments in the chart

i think u can do this by using general>errormess>custom mess

write a condition for that if(month='aug' 'high' or .....)

Not applicable

Re: Wanted to add comments in the chart

Hi Malek,

How to write that rank expression

Not applicable

Re: Wanted to add comments in the chart

Hi manoj,

It doesn't meet the requirement here you are hardcoding the values

sujeetsingh
Honored Contributor III

Re: Wanted to add comments in the chart

Shruti you can add another expression and then make it transparent.

maleksafa
Valued Contributor

Re: Wanted to add comments in the chart

rank( sum( Sales ))

it will return the rank within the chart, add a condition for example if ( rank( sum( Sales )) = 1,'Highest')

but first add it as a normal expression rank( sum( Sales )) to see what values it is returning. then add the if condition, and modify the display option to text as pop up.

jyothish8807
Honored Contributor II

Re: Wanted to add comments in the chart

Hi Sruti,

Hope this helps,

PFA

Regards

KC

Best Regards,
KC
jyothish8807
Honored Contributor II

Re: Wanted to add comments in the chart


If you want it as pop up then you can select text as pop up option and untick value at data point for second expression.

Regards

KC

Best Regards,
KC
Community Browser