topic Re: Names in QlikView

Names

arethaking — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

How to show report name as below:

If 2016 is selected then 2016 Current Year Sales

If 2015 is selected then 2015 Sales

if 2016 & JAN is selected then Jan-16 Sales

Thanks in advance.

Chanty4u — Thu, 01 Sep 2016 06:33:24 GMT

tresB — Thu, 01 Sep 2016 06:42:18 GMT

May be like in attached sample.

tamilarasu — Thu, 01 Sep 2016 06:44:47 GMT

Hi Aretha,

Have a look at the attachment.

Anonymous — Thu, 01 Sep 2016 07:00:42 GMT

Hi Aretha,

Try this code on the title:

=If(GetSelectedCount(Month)=0 and GetSelectedCount(Year) = 0,'Sales',

IF(GetSelectedCount(Month)=0,

If(GetSelectedCount(Year) = 1,

If(Year = Max({1} Year), 'Current Year Sales',Year &' Sales'),

Concat(DISTINCT Year,' - ',Year)&' Sales'),

If(GetSelectedCount(Month) = 1,

Month&'-'&Right(Year,2) &' Sales',

Concat(DISTINCT Month&'-'&Right(Year,2),', ',Year*100+Month) &' Sales')

)

Regards!

tamilarasu — Thu, 01 Sep 2016 08:03:23 GMT

Aretha,

I have almost covered all scenarios. Have a loo at the attachment.