Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading Variable Values in List Box

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.

1 Reply
Not applicable
Author

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.