topic Re: excluding current selections in QlikView

excluding current selections

Mon, 31 Dec 2012 15:25:00 GMT

I have a text box representing max(orderdate) , I need to keep it constant depending on the latest order....but when I am making other selections the order date is changing....so I need to use set analysis to exclude current selections.....Can anyone please post me code for my expression to exclude current selections.....

Re: excluding current selections

alexpanjhc — Mon, 31 Dec 2012 15:39:43 GMT

I would do it in my script with a variable and put that variable in the text box. That way you do not need to bother what is selected in the selction box.

Does that help?

Re: excluding current selections

Mon, 31 Dec 2012 16:52:02 GMT

I tried using variable in script as

set $(variable) = max(Orderdate);

I am getting an error aggregation expression cannot be used in group by....

Re: excluding current selections

alexpanjhc — Mon, 31 Dec 2012 17:45:11 GMT

you can't use that way.

do it like this:

test:

select max(orderdate) as Max

from ordertable;

Let vMaxDate = Peek('Max',0,'Test');

Re: excluding current selections

Nicole-Smith — Mon, 31 Dec 2012 18:19:10 GMT

To do it in the text box, just do max({1}orderdate). The {1} tells it to ignore all selections.

Re: excluding current selections

Mon, 31 Dec 2012 18:52:55 GMT

Thankyou, Its working perfect....