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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

excluding current selections

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.....

1 Solution

Accepted Solutions
Nicole-Smith

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

View solution in original post

5 Replies
alexpanjhc
Specialist
Specialist

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?

Not applicable
Author

I tried using variable in script as

set $(variable) = max(Orderdate);

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

alexpanjhc
Specialist
Specialist

you can't use that way.

do it like this:

test:

select max(orderdate) as Max

from ordertable;

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

Nicole-Smith

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

Not applicable
Author

Thankyou, Its working perfect....