Loading Variable Values in List Box

Mon, 12 Aug 2013 20:52:43 GMT

I'm definitely new to Qlikview, and I can't seem to wrap my head around this issue I have.

I am having a problem loading variable values in a list box so it is a selectable dimension.

Basically, I have two dates, and I needed a string value assigned to their difference as a list box value.

So the variable (vReorderStatus) is defined like this:

=if (round(([PredictedReorderDate]),1,1)-(Date#(Today()))<=-1

and round(([PredictedReorderDate]),1,1)-(Date#(Today())) >=-15, '1-15 Days Late',

if (round(([PredictedReorderDate]),1,1)-(Date#(Today())) <=-16

and round(([PredictedReorderDate]),1,1)-(Date#(Today())) >=-30, '15-30 Days Late'))

So then I create a listbox, and give the expression a value of =vReorderStatus.

But I don't get the full list of values, I only get one. When I select different accounts, it changes to their value, but it does not work as a filter for the overall data.

It's almost as if it's not working as a dimension.

What do I have to do to tie it to the entire matrix of information I'm viewing?

Should I load it as an inline table in my script, and then do a match((vReorderStatus), '1-15 Days Late', '15-30 Days Late', (vReorderStatus))? i read this somewhere but I'm not sure exactly how to do it or if it is the best solution, or if ti will even fix my problem.

Any help is greatly appreciated.

Thanks.

Re: Loading Variable Values in List Box

Tue, 13 Aug 2013 06:21:42 GMT

A variable only has one value at a time, so if you put it in a list box it will only show its current value. You should make it in the script. Tell exactly what you want to achieve with that, maybe there´s a better solution.

topic Loading Variable Values in List Box in QlikView

Loading Variable Values in List Box

Re: Loading Variable Values in List Box