topic Re: Select a field from alternate state in a set analysis in QlikView

Select a field from alternate state in a set analysis

edemerdjieva — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a expression which is filtered by a selection in field within alternate state.

The formula is as follows :

=Sum({COMPARATOR<Hour={"<=17"},[Store_id]=$::[Store_Id]>}[Sales])

It selects all sales for the day until 17:00 o'clock (store selection is optional).

The problem is that the hour selection should be dynamic rather than fixed (user interaction).

So, I figured out the formula like this:

=Sum({COMPARATOR<Hour={"<=MaxString({COMPARATOR}[Hour])"},[Store_id]=$::[Store_Id]>}[Sales])

And it'not working. I guess the syntax is wrong and QV could not evaluate MaxString({COMPARATOR}[Hour]).

Can you please help?

sunny_talwar — Thu, 20 Dec 2018 16:12:45 GMT

May be try this

=Sum({COMPARATOR<Hour = {"<=$(=MaxString({COMPARATOR}[Hour]))"}, [Store_id] = $::[Store_Id]>} [Sales])

edemerdjieva — Thu, 20 Dec 2018 16:14:30 GMT

Hi Sunny,

Glad to see you around :-).

Thanks, it worked !