topic Help with expression in Listbox in QlikView

Help with expression in Listbox

Tue, 28 Jun 2011 08:53:18 GMT

Hi,

I am trying to get a listbox to show values depending on certain criteria in an expression. ie.

=if(FINISHED='Y',

if(STATUS = 'SS' OR STATUS = 'WW' OR STATUS = 'IN',

if((fabs(CURRENT_INTERRUPTION_STARTDATE-'22/09/2010') <= 35 or fabs('22/09/2010'-CURRENT_EXIT_DATE) <= 35),

'Withdrawn','Not Withdrawn')))

When I try select 'Withdrawn' or 'Not withdrawn' in the listbox(in red), nothing gets filtered in the application.

I think it's the Date criteria in the expression that is not correct. Although the logic seems to be fine.

Any ideas on how to correct this? I've attached the sample .qvw

Many thanks

kaushiknsolanki — Tue, 28 Jun 2011 09:12:51 GMT

Hi,

When you try the same expression in chart it works.

Can you describe how you want to use this. and whats the functional requirement, with example.

Regards,

Kaushik Solanki

Tue, 28 Jun 2011 09:22:35 GMT

Yes, it seems to work just fine in the chart.

I basically want a listbox with Withdrawn and Not withdrawn, using the specified criteria.

kaushiknsolanki — Tue, 28 Jun 2011 09:25:54 GMT

Hi,

I would suggest you to include this calculation while loading the data.

As i can see from the table view you are using only 1 table. So the same expression will work for sure.

Regards,

Kaushik Solanki

deepakk — Tue, 28 Jun 2011 09:33:09 GMT

Hi Beanz,

Try this out.

1) Create a new field with (Current_Inspection_Date - '29/10/2010' ) as NewField

2) Add the new field to the condition and remove Current_Inspection_Date - '29/10/2010'.

This might work.

Deepak

Tue, 28 Jun 2011 09:33:24 GMT

Thanks, I'll try that out.

llauses243 — Wed, 29 Jun 2011 13:27:37 GMT

Hi Beanz,

This is my offer ... pls see attach

Good luck, Luis