Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

YoussefBelloum
Esteemed Contributor

Re: List box multiple selection and variable not working

so if you select two fiscal years (2015-2016, 2016-2017), you need to show 4 quarters corresponding to the years selected ??

milindnikumbh
New Contributor III

Re: List box multiple selection and variable not working

Yes. I will replicate first chart two times. then change the subfiled value 1 / 2 / 3 respectively. Rest is same.

woshua5550
Contributor III

Re: List box multiple selection and variable not working

you mean it should look like this ?

微信截图_20171123173530.png

milindnikumbh
New Contributor III

Re: List box multiple selection and variable not working

This will be helpful. Either in one chart or 4 different charts with 4 quarters

milindnikumbh
New Contributor III

Re: List box multiple selection and variable not working

Can you please share the qvw

milindnikumbh
New Contributor III

Re: List box multiple selection and variable not working

Dear Dave ,

Please share me the above result QVW by the time.

Regards,

Milind.

Highlighted
woshua5550
Contributor III

Re: List box multiple selection and variable not working

Hi Milind

PFA

milindnikumbh
New Contributor III

Re: List box multiple selection and variable not working

Dear Dave,

Thanks. I have resolved this using following expression. But still worried about qlik behavior . Its showing / bifurcating the multiple fiscal year in text item but I was not able to use it in expression. So I have written variable code directly in expression like this :

=If ( FiscalYear = SubField (GetFieldSelections([FiscalYear] , ', ',3),', ',1) ,
(
Round ( if(getcurrentfield(CLY)='PRODT', sum([PRODUCTION TONS]) ,
if(getcurrentfield(CLY)='PRODQ', sum(
[PRODUCTIN(A+B)]) ,
if(getcurrentfield(CLY)='SCRAPT', sum(
[Scrap Tonnage]) ,
if(getcurrentfield(CLY)='SCRAPQ', sum(
[Scrap Qty]) ,
if(getcurrentfield(CLY)='SCRAPP', ( sum(
[Scrap Tonnage]) / sum([PRODUCTION TONS]) ) * 100
)
)
)
)
)
)
)
,0)

Thank you so much for your instant help.

Regards,

Milind.