topic Help with if Statement in QlikView

Help with if Statement

Thu, 14 Nov 2013 11:33:29 GMT

Good Day

Can anyone please help with setting a "default" clear selection for an if statement. I have a variable called vWeek which is assigned the following value

=if(Week = '' ,Week(Today()),Week)

"Week" is a listbox populated with the weeks of the year currently running from week 31 - 46.

I would like to display the selected week value in a textbox. The above formula shows the week value e.g. 43, in the textbox when week 43 was selected in the listbox, but how do I show the current week in the textbox if no week was selected in the listbox. I basically want to do the following

If nothing selected in the week listbox

=if(Week = "Nothing Selected", Show current week, else show week selected)

=if(Week = "Nothing Selected", Week(Today()), Week)

Thank You

Re: Help with if Statement

swuehl — Thu, 14 Nov 2013 11:35:35 GMT

=if(GetSelectedCount( Week ) = 1, Week, Week(today()) )

Re: Help with if Statement

kaushiknsolanki — Thu, 14 Nov 2013 11:37:32 GMT

Hi,

Try this.

=if(GetfieldSelections(Week) = 0,Week(Today()),Maxstring(Week));

Regards,

Kaushik Solanki

Re: Help with if Statement

Thu, 14 Nov 2013 11:43:33 GMT

Thank you

Works brilliantly. Exactly what I was looking for.

Regards

Cobus

Re: Help with if Statement

Thu, 14 Nov 2013 11:47:18 GMT

Hi This will work

ListWeek=1,2,3,4,5,6

=if(GetfieldSelections(ListWeek) = 0,Week(Today()),Maxstring(ListWeek))