topic Re: Need Help? in QlikView

Need Help?

paulwalker — Mon, 19 Jan 2015 16:39:43 GMT

Hi Community,

I have a Bar chart, Grouping dimension.

when i am click cycle/Drill group i want change caption.

if i am click Div----> Division wise cost

Grade--> Grade wise cost

Status----> Status wise cost..

PFA,

chrismarlow — Mon, 19 Jan 2015 16:49:53 GMT

Start with;

getcurrentfield( [New Group] )

Then add some logic (a couple of If statements?) to get the display exactly how you want.

Mon, 19 Jan 2015 16:51:24 GMT

Paul, you need this windows title expression:

=if(getcurrentfield([New Group])='Div','Division wise cost',

if(getcurrentfield([New Group])='Grade','Grade wise cost',

if(getcurrentfield([New Group])='Status','Status wise cost')

)

stigchel — Mon, 19 Jan 2015 16:55:15 GMT

See attached using GetCurrentField()

Mon, 19 Jan 2015 16:57:50 GMT

Hi Paul,

as the guys have said get current field is your friend here, if you want to avoid nested if statements, the attached should work for you

hope that helps

Joe

paulwalker — Mon, 19 Jan 2015 17:07:26 GMT

Nice work Simmons....