Dynamic Dimension for Listbox

[#1]

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.

[#2]

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

JG

[Oleg_Troyansky]

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. 

[#4]

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

[Anonymous]

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