topic Re: Dynamic Dimension for Listbox in QlikView

Dynamic Dimension for Listbox

Fri, 01 Feb 2013 20:07:10 GMT

Hi QlikViewers,

Need one help please. I am trying to implement a list box for Year values. I want the list box to pickup year values from a source data filed "Fiscal Year" if vFiscalVariable = 1 and pickup year values from Source data field "Calendar year" when vFiscalVariable = 0.

I have create a button to toggle the value of vFiscalVariable to 0 and 1 on button click.

Re: Dynamic Dimension for Listbox

Fri, 01 Feb 2013 20:11:08 GMT

Use the Conditional Show property to show one listbox or another:

Re: Dynamic Dimension for Listbox

Oleg_Troyansky — Fri, 01 Feb 2013 20:11:44 GMT

You can either specify an Expression in the List Box or keep 2 "regular" List Boxes, one for the field Year and the other one fo the field "Fiscal Year", and show/hide one of the two List Boxes based on the toggle value.

Re: Dynamic Dimension for Listbox

Fri, 01 Feb 2013 20:16:14 GMT

I can hide for sure.

But wanted to use expression to achive that result using one listbox only. Any ideas

I can toggle the variable using a button action.

I also used an expression like this in the listbox. =if(vFiscalTgl = fy_year,calendar_year,fy_year). but it changes both Calendar and Fiscal values together.

Thanks

Raghu

Re: Dynamic Dimension for Listbox

Anonymous — Thu, 23 May 2013 11:48:59 GMT

Please use the following steps to achive this:

1. Populate the field Fiscal year.

2. Right click on the Fiscal Year List box and go to the "Properties".

3. In the "General" tab you have "Field" dropdown.

4. Open this dropdown and select the last value which is "<Expression>".

5. Now enter the following formula: If(vFiscalVariable=1,[Fiscal Year],[Calendar Year])

The [Fiscal Year] and [Calendar Year] are your fields in the backend.

Thanks!!!

-Abhishek