topic Re: chart label display by selection in QlikView

chart label display by selection

Anonymous — Tue, 28 Apr 2015 04:56:19 GMT

Hi Gurus,

I want to display my 3 selections seperated with ':' in chart window titel

Please find the sample xl file

required output format: 2014:Jan:Q1

I have year Field:2014,2015

Yearquarter:14-Q1( need to Bring only Q1 in lable)

Month Year:Jan-14(need to Bring only Month )

Thanks inadvance

petter — Tue, 28 Apr 2015 05:03:40 GMT

This should work:

=Min(Year) & ';' & MinString(Month(Month)) & ';' & Right(MinString([Quarter year]),2)

tresB — Tue, 28 Apr 2015 05:05:55 GMT

Check attached qvw

Tue, 28 Apr 2015 05:08:13 GMT

You can use this ... But there should be always one selected ..

=Year&':'&Month(Month)&':'&Right([Quarter year],2)

Anonymous — Tue, 28 Apr 2015 05:18:15 GMT

Hi tresesco,

Thanks for your Time.

If i select only Month it should display :Jan

it would be getfield selections based

thanks,

tresB — Tue, 28 Apr 2015 05:31:20 GMT

Like this? PFA

Note, you can avoid the ';' symbols as well by checking null in a condition under if clause.