Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How filter independent of selections

Hello everybody.

I need help with that.

I have two selectors client and year

client  year   month

client1 2012  ene

client1 2012 feb

client1 2012 mar

client2 2012 ene

If a select a client1 and year 2012 i have rows for that client in ene,feb,mar

but i select a client2 i have rows only for ene

I need show in a text box the min month and the max month independent of which client i selected.

If i select client1 show ene/mar and the same action with client2

How i write a expression that retrieve the min of mont based on the year selected independent of the client.

Thanks in advance.

1 Solution

Accepted Solutions
Not applicable
Author

Min({$<client=>}month) should return min month irregardless of client.

View solution in original post

1 Reply
Not applicable
Author

Min({$<client=>}month) should return min month irregardless of client.