topic Help text in QlikView

Help text

srinivasa1 — Fri, 03 Feb 2012 11:18:54 GMT

Help text in chart as bellow

=if(EmpID='01',Emp_Name) but its not showing anyhelp text.my data as bellow

EmpID ,Emp_Name

01 ,Mohan

02, Ram

03, B etc. pls help me how i can achive this i need to set if empid=01 then name will be mohan.

thanks in advance

Help text

stephencredmond — Fri, 03 Feb 2012 11:28:18 GMT

Hi,

HelpText in a Chart (Caption tab) is calculated across the whole dataset, not line by line. Therefore, if you have more than 1 Employee selected, EmpID will have more than one value so EmpID='01' will be meaningless.

Depending on the type of chart you are creating, you could perhaps add an additional Expression to calculate the text you want to popup and turn off the, say, "Bar" option and turn on the "Text as popup" option.

Regards,

Stephen

Help text

srinivasa1 — Fri, 03 Feb 2012 11:36:20 GMT

Im useing gauge chart

Re: Help text

stephencredmond — Fri, 03 Feb 2012 11:45:30 GMT

Hi,

Have a look at this example. Does that give you an idea of how to do what you need?

Regards,

Stephen

Help text

srinivasa1 — Fri, 03 Feb 2012 12:07:36 GMT

Hi i need to add helptext.

Re: Help text

Fri, 03 Feb 2012 12:46:42 GMT

Hi,

U need to add help text in caption?

Go to caption tab, in the help text box add yours code:

if(EmpID=01, 'Mohan',

if(EmpID=02, 'Sulistiyo'

)) // remember to have this close bracket, if you have 3 IF, then you must close it with 3 bracket also.

If you want to always appear along in the chart, u can use "Text in Chart", located in tab "Presentation"

hope it helps..

Help text

srinivasa1 — Fri, 03 Feb 2012 14:11:11 GMT

I need to disply one help only as bellow employee

if(EmpID=01, 'Mohan') for one object (obj1), other employeee i wll need to disply help text in other object ie:(for obj2 it will be name of emp code 2) thx

Re: Help text

Fri, 03 Feb 2012 14:21:45 GMT

hmm..i dont really understand with what you are trying to achieved. Any example or screenshot?

Help text

srinivasa1 — Tue, 07 Feb 2012 07:12:19 GMT

Hi ,

Sorry for dealy to reply i was bit bussy last 2 days.. i need to create dynamic help text for cauge chart.. thx.

Re: Help text

Mon, 13 Aug 2012 13:05:57 GMT

Sorry about the late response but I stumbled upon this researching my own problem.

I assume Emp_Name is associated in your data model.

if(getpossiblecount(Emp_Name)=1,Emp_Name,'Various Employees')