topic Re: Static expression in QlikView

Static expression

patrou38 — Fri, 24 Nov 2017 08:04:01 GMT

Hello,

I need to have a static expression, mean not depending to any filters selected.

In my example attached, the chart not change if no weeks selected or I flast week (46) is selected. this is a good behavior, but If I select an other week the chart becomes blank and my target is that I would like to show always the last week (week 46 in my example).

I hope that I was enough clear.

thank you in advance for your help.

regards,

Patrick

Re: Static expression

jonathandienst — Fri, 24 Nov 2017 08:10:43 GMT

Use {1} as rge base set in a set expression. This ignores all selections. Like this:

=Sum({1} Amount) // ignore all selections

=Sum({1<Week = {"$(=Max(Week))"}>} Amount) // last week or last selected week

=Sum({1<Week = {"$(=Max({1} Week))"}>} Amount) // last week

Re: Static expression

patrou38 — Fri, 24 Nov 2017 08:36:54 GMT

thank you for your quick answer.

Re: Static expression

patrou38 — Fri, 24 Nov 2017 14:02:00 GMT

One more question, it's works as it is ( =count({1<Week={$(vPreviousWeek)}>}Lot) ) with one or more static 'field'.

but if I would like to have 1 static field (without any action in the amount), like Week in this example but other filters potentially selected able to modified the result of the expression.

I don't know if I'm clear... in my example the Week is frozen, but I want that if I select a Site, the amount must be impacted.

Re: Static expression

jonathandienst — Mon, 27 Nov 2017 04:51:42 GMT

I am a little confused

original post >> mean not depending to any filters selected

and

now >> the amount must be impacted

So which is it? {1<...>} will override the other selections as you requested in your original post. Or if you want to respect selections use {$<...>}. If you want to ignore slections in all fields except one or two, then use

{1<Field1 = $::Field1, ....>}

Re: Static expression

patrou38 — Tue, 28 Nov 2017 08:34:57 GMT

Hello Jonathan ,

Sorry to make you confused.

You're right, my request evoluted. now in the same expression, I would like to freeze 1 field (Week in my example) but I want the chart potentially modified when the user select 1 site or 1 people (see my attached example )

Expression used in the chart are:

= count({1<Week={$(vMaxWeek)}>}Lot)

=sum({1<Week={$(vMaxWeek)}>}NotFoundInEDA)

Thank you in advance.

regards

Re: Static expression

jonathandienst — Wed, 29 Nov 2017 09:25:03 GMT

Just remove the 1 from the set expressions so that all other fields respond to user selections in the normal way.

If that is not what you after, I suggest that you start a new thread.