Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Year and Month Select Change other field

Hi community,

I have an inline load of month and year that I use for selection in part of my document.  It has an odd format with '01-FEB', '02-MAR' being the month. 

What I'd like is for the list box of this inline loaded month and year to influence the selection of a different field called QBperiod that has values '01', '02' for march and feb. 

Also a bonus would be if the selection of 2013, '02-MAR' would select QBPeriods, '01', '02' and all of the previous years like 2012, 2011...

1 Reply
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Then you need to load inline as

     Load *,Left(Month,2) as QBPeriods Inline

[Month

01-FEB

02-MAR

.

.

.

.

.];

Celambarasan