topic Re: List box based on expressions in QlikView

List box based on expressions

Tue, 07 Jan 2014 10:48:29 GMT

Hi Experts,

I am facing couple of challanges that have been listed below.

1- I need 2 create a list box containing the expressions that i have used in the chart

a- Hi-Tech

b- CTS & Media

c- Software

d- Fin-serv

2- The 'Hghest revenue Generating vertical' should be default show the the overall (all 4 yaers)...In thsi case software and its corresponding revenue. Currently, i have hard coded it. These 2 should be cahnged if a particular year is selected.

Would appreciate your assitance on This

Re: List box based on expressions

jagan — Tue, 07 Jan 2014 11:14:25 GMT

Hi,

Please check the script and expressions in the attached file.

Regards,

Jagan.

Re: Re: List box based on expressions

Tue, 07 Jan 2014 11:33:24 GMT

Hi,

Thanks for looking into this.

Have you changed something in the backend data?..i can see the cross table code. I cant change teh file format now...Atatching the file format for your reference.

Also, i need a list box containing the the dimensions as below:

a- Hi-Tech

b- CTS & Media

c- Software

d- Fin-serv

Re: List box based on expressions

Tue, 07 Jan 2014 15:13:13 GMT

any help?

Re: List box based on expressions

jagan — Wed, 08 Jan 2014 02:58:09 GMT

Hi,

I didn't changed your data, just exported data to Excel and did the changes in script and expressions. There is no need to change the File Format we are just transforming the data which suits for the report. For list box just add Type as listbox, you will get that.

Regards,

Jagan.

Re: List box based on expressions

Wed, 08 Jan 2014 11:11:45 GMT

Hi Jagan,

Thanks for your help. I understood the logic of cross table. Thanks