Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
reshmakala
Creator III
Creator III

Listbox Valuelist

Hello all,

I have a list box that gets values from an if condition. My expression is:

=if(Month='1','Jan',

if(Month='2','Feb',

if(Month='3','Mar',

if(Month='4','Apr',

if(Month='5','May',

if(Month='6','Jun',

if(Month='7','Jul',

if(Month='8','Aug',

if(Month='9','Sep',

if(Month='10','Oct',

if(Month='11','Nov',

if(Month='12','Dec'))))))))))))

I get only Oct and Nov based on some transactions. How can put in some dummy values for the months that are not displayed?

I want to display all 12 months, though there are only 2 months which can be selected.

1 Reply
its_anandrjs
Champion III
Champion III

Hi,

Better if you use application with the master calendar then you get all Month value weather it is in transaction or not.

Regards

Anand