topic Re: list box value in current selection in QlikView

list box value in current selection

Anonymous — Wed, 19 Aug 2015 12:40:02 GMT

Hello everyone,

I have created one list box and current selection. If i select year value in list box that value is not displaying properly in current selection.

It is displaying no of days in that particular year. But I want to display as year value.

In script to get year value I used like this

if(year([DW Load])>=2014,[DW Load]) as listbox

in list box i used year(listbox)

Regards,

Kumar

Re: list box value in current selection

Gysbert_Wassenaar — Wed, 19 Aug 2015 12:42:48 GMT

That's because Year is not a field, but a result of an expression. When you click on a value you don't select a year, but all the values that were used to calculated the year value. You could try creating the listbox field as if(year([DW Load])>=2014,year([DW Load])) as listbox

Re: list box value in current selection

vishsaggi — Wed, 19 Aug 2015 12:44:22 GMT

Hello Kumar,

I believe you have already raised this query before here current selection issue.

However, can you upload your sample app so that we can try on it quickly.

Thanks,
V.

Re: list box value in current selection

Anonymous — Wed, 19 Aug 2015 12:46:43 GMT

Even i tried that one also, but no use. Actually [DW Load] it is a timestamp.

Re: list box value in current selection

Anonymous — Wed, 19 Aug 2015 13:04:56 GMT

pfa

Re: list box value in current selection

vishsaggi — Wed, 19 Aug 2015 13:26:26 GMT

Hi Kumar,

Can you try this and let me know if this works. I cant try at my end as I have to reload it to refresh the script.

dim_date:

Load DateOnly,

Year(listbox) As Listbox;

load

Date(Floor([Time Full Date])) AS DateOnly,

if(year([Time Full Date])>=2014, [Time Full Date]) as listbox

Resident Dim_time;

Re: list box value in current selection

vishsaggi — Wed, 19 Aug 2015 13:28:51 GMT

Can i also know the specific reason of not using your [Time Year Number] as your Year Field and use this expression in listbox like

= If([Time Year Number]>= 2014, [Time Year Number])

Let me know.

Re: list box value in current selection

Anonymous — Wed, 19 Aug 2015 13:35:45 GMT

That is so great. can you explain little how it is working now.

Re: list box value in current selection

Anonymous — Wed, 19 Aug 2015 13:38:54 GMT

Is there any way to display listbox name in current selection. Thanks for ur support. That is perfectly working

Regards,

Kumar

Re: list box value in current selection

vishsaggi — Wed, 19 Aug 2015 13:46:12 GMT

Hello Kumar,

I quite did not get you, you mean the field used in the listbox to be displayed in Current selection or the title Current selection to be renamed to the field name.??

And would you mind tagging the response as correct so that other users will be helped.

Thanks,
V.

Re: list box value in current selection

vishsaggi — Wed, 19 Aug 2015 13:48:30 GMT

Great it worked for you. There i have just used a preceding load before the actual transformation happened in the actual load. Then used the Year function as you know it.