topic Re: Missing Field values in Listbox in QlikView

Missing Field values in Listbox

Thu, 19 Feb 2015 09:58:59 GMT

Hi friends,

I have taken nested if conditions and when I am taking Listbox for Buckets field I did not get the Future column in List box.

if(Bucket=1,'0-30',if(Bucket=2,'31-60',if(Bucket=3,'61-90',if(Bucket=4,'91-120',if(Bucket=5,'121-180',if(Bucket=6,'181-360',if(Bucket=7,'361-540',if(Bucket=8,'Over540')))))))) as Buckets

Please help me. Its Urgent.

Thanks,

Chandu

Re: Missing Field values in Listbox

Thu, 19 Feb 2015 10:04:14 GMT

if(Bucket=1,'0-30',if(Bucket=2,'31-60',if(Bucket=3,'61-90',if(Bucket=4,'91-120',if(Bucket=5,'121-180',if(Bucket=6,'181-360',if(Bucket=7,'361-540',if(Bucket=8,'Over540',if(Bucket=9,'Future')))))))) as Buckets

I took like this query but it is not working

Re: Missing Field values in Listbox

Thu, 19 Feb 2015 10:08:39 GMT

You are missing a bracket on this

Re: Missing Field values in Listbox

Thu, 19 Feb 2015 10:12:28 GMT

Another option you have for this rather than a nested if like that is an apply map

GroupMap:

Load * inline [

single, group

1,0-30

2,31-60

3,61-90

4,91-120

5,121-180

6,181=260

7,361-540

8,Over540

9,Future

];

Data:

Load

Applymap('GroupMap',Bucket) AS Buckets

......

hope that helps

Joe

Re: Missing Field values in Listbox

Anonymous — Thu, 19 Feb 2015 10:59:37 GMT

ApplyMap is the best option in this type of problem ... when you know all the values and their required values. .. as suggested above you can go with Applymap.