Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
milindnikumbh
Creator
Creator

List box multiple selection and variable not working

Dear Experts ,

Greetings !

Attached is the my document. Its working fine when I select the single Fiscal Year . But when I select multiple fiscal years, my last graph is not displaying the data. All variables are populating data correctly in text item. But not able to use in expression.

You suggestions / help is highly appreciated.

Thanks.

Regards,

Milind.

17 Replies
YoussefBelloum
Champion
Champion

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

milindnikumbh
Creator
Creator
Author

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

woshua5550
Creator III
Creator III

you mean it should look like this ?

微信截图_20171123173530.png

milindnikumbh
Creator
Creator
Author

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

milindnikumbh
Creator
Creator
Author

Can you please share the qvw

milindnikumbh
Creator
Creator
Author

Dear Dave ,

Please share me the above result QVW by the time.

Regards,

Milind.

woshua5550
Creator III
Creator III

Hi Milind

PFA

milindnikumbh
Creator
Creator
Author

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.