Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
edemerdjieva
Partner - Creator
Partner - Creator

Select a field from alternate state in a set analysis

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?

1 Solution

Accepted Solutions
sunny_talwar

May be try this

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

View solution in original post

2 Replies
sunny_talwar

May be try this

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

Hi Sunny,

Glad to see you around :-).

Thanks, it worked !