topic Re: Show title based on choosen expression label in QlikView

Show title based on choosen expression label

Thu, 26 Mar 2015 13:49:58 GMT

Hi,

I have grouped my expressions as they are Quantity and Income in my bar chart. I want to show the the title on the one whose choosen expression. If I chose quantity window title or chart title should show the sum(Quantity), otherwise If I chose Income, then title show sum(Income) like this... How can i do that ? Could you please advice me?

Thanks

Regards

Kezy

Re: Show title based on choosen expression label

northerner — Thu, 26 Mar 2015 14:16:21 GMT

Hi Kezy,

Have you tried the GetCurrentField() function?

The syntax is: GetCurrentField(groupname) - if you specify the name of your group, the function will return the currently selected value.

Hope this helps!

Re: Show title based on choosen expression label

Thu, 26 Mar 2015 14:26:03 GMT

Hi Northerner

Thanks for reply But;

As you see it is getcurrentfield it doesnt work with group. It works with Field ☹

Re: Show title based on choosen expression label

northerner — Thu, 26 Mar 2015 14:56:01 GMT

Hi Kezban,

You're right - that's not going to work. I have another idea:

Make sure that General->WIndow Title and Caption->Title Text are blank. On the 'General' tab, check that 'Show Title in Chart' is selected. The text box underneath should show <use first expression label>. You should now see the label of the active expression in the title bar.

Hopefully this should work for you

Re: Show title based on choosen expression label

Thu, 26 Mar 2015 15:00:52 GMT

Hi North,

It is unbelieavable. You cant imagine how much time I have spent and couldnt find. How did you find it ? Thanks it works perfect well.

Very grateful

Cheers

Re: Show title based on choosen expression label

Thu, 26 Mar 2015 15:04:28 GMT

I forgot to ask in the last mail the last thing that;

Can I also show sum(quantitiy) near the ??? that would be great

Many thanks

Re: Show title based on choosen expression label

northerner — Thu, 26 Mar 2015 15:11:00 GMT

Hi Kezban,

I'm not quite sure what you mean here - are you asking if it's possible to show the value of the expression total in the title bar?

Re: Show title based on choosen expression label

Thu, 26 Mar 2015 15:19:28 GMT

Yes I exactly have asked that.

Thanks İf you could give you advice.

Re: Show title based on choosen expression label

northerner — Thu, 26 Mar 2015 15:24:09 GMT

I can think of one possible solution - you could include the expression total in the expression label, with a calculation something like: ='Total Quantity ' & sum(Quantity)

The problem is that you will see the expression total in the column title, which you might not want to do.

Re: Show title based on choosen expression label

awhitfield — Thu, 26 Mar 2015 15:25:12 GMT

Hi Kezban,

Can you post your QVW?

Andy

Re: Show title based on choosen expression label

Thu, 26 Mar 2015 15:25:39 GMT

try with this

getfieldselections(groupname)