topic multi selection with one click in QlikView

multi selection with one click

canariam — Sat, 10 Jul 2010 19:14:42 GMT

hi all,

i need your help.i m trying to creat a custom list box or smth like that.

it has to contains these:

my list box

last 3 days

last week

last 2 weeks

last month

last 3 months

last year

when i click 1st row, my report must change and show only values of last 3 days etc.

ex:

i can do custom list box.it s an example from online sales.when u write below text to expression in the list box fields:

=if(right(date(OrderDate,'DD.MM.YYYY'),4)='2006','2006')&

if(right(date(OrderDate,'DD.MM.YYYY'),4)='2007','2007')&

if(right(date(OrderDate,'DD.MM.YYYY'),4)='2008','2008')

RETURNS:

2006

2007

2008

but when it is needed to use functions like max min etc,it doesnt work.

how can i do tihs?

thanks in advance,

multi selection with one click

pover — Sat, 10 Jul 2010 20:27:04 GMT

Create an inline table with the values you want in the list box. The table should have no relation with any other table in the data model. Think you can either create an expression with an if. For example, if(Column='last 3 days', sum(if(date<today() and date > today()-3 value)),...). The if for the date can also be set analysis. Or if you have loads of expression, you can create an action that makes a selection of the last 3 days, last week, etc. and that action is triggered when you select the column.

Regards, Karl

multi selection with one click

johnw — Tue, 13 Jul 2010 02:19:38 GMT

Actually, I'd create the values for the list box in an inline load, but then explicitly connect those values to the correct dates. It should then behave properly with no special chart coding. Rob Wunderlich has an example of this in his cookbook:

http://robwunderlich.com/Download.html

The application in the cookbook is dategrouping.qvw.