topic Re: Get Values and Display in QlikView

Get Values and Display

Mon, 18 Mar 2013 03:56:08 GMT

Hi All,

Just want to ask on how can i display the selected value in the title of my chart.

In the screenshot shown: If I select Controllable in the Category, it should display the list of controllables, and the title should be: Posted Credit Memo Per Responsibility Center - Controllable

Thanks All

-Donna

Re: Get Values and Display

Anonymous — Mon, 18 Mar 2013 04:00:49 GMT

Maybe something like:

='Posted Credit Memo Per Responsibility Center - ' & if(len(Category)=0,'All', Category)

Re: Get Values and Display

Mon, 18 Mar 2013 04:23:23 GMT

my Category is currently under a Drilldown Group. How can I show it if it is in a group? Thanks

Re: Get Values and Display

Mon, 18 Mar 2013 04:30:05 GMT

Hi,

in my point of view Groups Cant shown on title. But i dont no exactly

Re: Get Values and Display

udit_kumar_sana — Mon, 18 Mar 2013 04:54:03 GMT

Hi,

You can try this expression in Windows tile of your chart:

=if(WildMatch(category,'Controllable'), 'Posted Credit Memo Per Responsibility Center - Controllable',

if(WildMatch(category,'UnControllable'), 'xyz' ,

if(WildMatch(category,'N/A'), 'abc' )))

Regards,

Udit

Re: Get Values and Display

sushil353 — Mon, 18 Mar 2013 06:15:02 GMT

can u upload the sample application.

you can also try to use getselectedvalue function.

HTh

Sushil

Re: Get Values and Display

jagan — Mon, 18 Mar 2013 07:45:11 GMT

Hi,

You can get the current dimension in the drilldown group by using GetCurrentField(), and you can get the selected values by getfieldselections ( ), now concatenating this you can frame the title.

= 'Some string ' & GetCurrentField(DrillDownGroupName) & getfieldselections ( FieldName [, ValueSep [, MaxValues]])

Hope this helps you.

Regards,

Jagan.