topic List box multiple selection and variable not working in QlikView

List box multiple selection and variable not working

milindnikumbh — Thu, 23 Nov 2017 08:19:59 GMT

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.

Re: List box multiple selection and variable not working

YoussefBelloum — Thu, 23 Nov 2017 08:46:04 GMT

Hi,

it is not populating correctly because of the SubField function Subfield(Fyr,', ',1).

t takes only the first fiscal year if yo select 2

why do you use this condition actually ?

Re: List box multiple selection and variable not working

mdmukramali — Thu, 23 Nov 2017 08:50:03 GMT

Hi Milind,

i look at your expression which you are using in the chart.

i didn't found any field or variable with the name CLY .

from where you are using CLY ?

Re: List box multiple selection and variable not working

woshua5550 — Thu, 23 Nov 2017 08:55:53 GMT

Hi ,it's a group name

Re: List box multiple selection and variable not working

isorinrusu — Thu, 23 Nov 2017 09:04:17 GMT

Try this in your expression:

=Round ( if(getcurrentfield(CLY)='PRODT', sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[PRODUCTION TONS]) ,

if(getcurrentfield(CLY)='PRODQ', sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[PRODUCTIN(A+B)]) ,

if(getcurrentfield(CLY)='SCRAPT', sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[Scrap Tonnage]) ,

if(getcurrentfield(CLY)='SCRAPQ', sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[Scrap Qty]) ,

if(getcurrentfield(CLY)='SCRAPP', ( sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[Scrap Tonnage]) / sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[PRODUCTION TONS]) ) * 100

)

Re: List box multiple selection and variable not working

woshua5550 — Thu, 23 Nov 2017 09:05:08 GMT

if user selected '2013-2014' & '2014-2015' , what data do you want to show ? '2013-2015' ?

Re: List box multiple selection and variable not working

milindnikumbh — Thu, 23 Nov 2017 09:29:26 GMT

Then it will show all quarters of 2013-2014 in one chart and I will deploy same chart for 2014-2015 .

Re: List box multiple selection and variable not working

milindnikumbh — Thu, 23 Nov 2017 09:29:38 GMT

Its not working.

Re: List box multiple selection and variable not working

milindnikumbh — Thu, 23 Nov 2017 09:30:27 GMT

I need to show bar chart per year. ( all quarters in one graph ).

Re: List box multiple selection and variable not working

milindnikumbh — Thu, 23 Nov 2017 09:32:27 GMT

this is giving error :

=Round ( if(getcurrentfield(CLY)='PRODT', sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[PRODUCTION TONS]) ))

Re: List box multiple selection and variable not working

YoussefBelloum — Thu, 23 Nov 2017 09:33:03 GMT

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

Re: List box multiple selection and variable not working

milindnikumbh — Thu, 23 Nov 2017 09:34:48 GMT

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

Re: List box multiple selection and variable not working

woshua5550 — Thu, 23 Nov 2017 09:36:19 GMT

you mean it should look like this ?

Re: List box multiple selection and variable not working

milindnikumbh — Thu, 23 Nov 2017 09:39:40 GMT

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

Re: List box multiple selection and variable not working

milindnikumbh — Thu, 23 Nov 2017 09:44:25 GMT

Can you please share the qvw

Re: List box multiple selection and variable not working

milindnikumbh — Thu, 23 Nov 2017 10:11:55 GMT

Dear Dave ,

Please share me the above result QVW by the time.

Regards,

Milind.

Re: List box multiple selection and variable not working

woshua5550 — Thu, 23 Nov 2017 11:06:48 GMT

Hi Milind

PFA

Re: List box multiple selection and variable not working

milindnikumbh — Thu, 23 Nov 2017 11:36:50 GMT

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.