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: 
warrentk80
Creator
Creator

Set Analisys - minor operator

Good morning everyone, I would need to use in a set analysys formula, the minor operator.

for example I have to take in a text box all the sales from the beginning year to the selected month.

the forum that I use for the sale of the month is:

sum ({1 <[MonthSale] = {'$ (= V_MeseSerie)'}, Sales)

how do I insert the minor operator?

Thanks 1000

Andrew

5 Replies
YoussefBelloum
Champion
Champion

Hi,

what do you mean by this "..all the sales from the beginning have to the selected month." ?


what is the content of this variable V_MeseSerie?

warrentk80
Creator
Creator
Author

sorry, if I select may I have sales from January to May, if you select July sales from January to July, etc .....

Thanks 1000

Andrew

YoussefBelloum
Champion
Champion

ok, how did you declared your V_MeseSerie variable ?

warrentk80
Creator
Creator
Author

V_MeseSerie is the month of the selected date.
in the set analysis I do not know if I can control between fields, so I use a variable

YoussefBelloum
Champion
Champion

Supposing that your MonthSale field values are this: 1, 2, 3, 4, 5 ... you will need something like this:

=Sum({<[MonthSale] = {">=$(=GetFieldSelections([MonthSale] ))"}>}sales)