topic Re: Set Analisys - minor operator in QlikView

Set Analisys - minor operator

warrentk80 — Tue, 17 Jul 2018 09:08:17 GMT

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

Re: Set Analisys - minor operator

YoussefBelloum — Tue, 17 Jul 2018 09:16:04 GMT

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?

Re: Set Analisys - minor operator

warrentk80 — Tue, 17 Jul 2018 09:22:00 GMT

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

Re: Set Analisys - minor operator

YoussefBelloum — Tue, 17 Jul 2018 09:27:33 GMT

ok, how did you declared your V_MeseSerie variable ?

Re: Set Analisys - minor operator

warrentk80 — Tue, 17 Jul 2018 10:19:28 GMT

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

Re: Set Analisys - minor operator

YoussefBelloum — Tue, 17 Jul 2018 11:41:49 GMT

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

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