
Re: In one dimension, the amount of pull of the maximum sum value of another dimension.
Sunny Talwar Aug 18, 2016 4:35 AM (in response to Владимир Фасюра)Can you try this:
FirstSortedValue(Aggr(Sum(Sales), Period, Product), Aggr(Period, Period, Product))

Re: In one dimension, the amount of pull of the maximum sum value of another dimension.
Владимир Фасюра Aug 18, 2016 5:26 AM (in response to Sunny Talwar )thanks for the answer.
But this method, I also tried.
Same result as sum ({<Period = { '$ (= max (Period))'}>} Sales)
Visible only those products for which the period is the maximum..
for example, sales are 10 products in the last month.
Here it will be shown on the data in your example..
But the data will not be displayed on products, whose sales were 3 months ago .. 4 months ago. etc
I tried a variety of methods.
I am satisfied with the period that is shown when I enter into a separate column expression =max(Period) .. without "$"
for example.. "Apple" last Sales at 201205 10000$
=max(Period) will be ‘201205’
but when I try to put this condition in the expression sum ({<Period = { '$ (= max (Period))'}>} Sales) The result is 0$,
Because =$ (= max (Period)) ... = 201412 (its max date of Data table)
in your example, the results are exactly the same +(

Re: In one dimension, the amount of pull of the maximum sum value of another dimension.
Sunny Talwar Aug 18, 2016 5:43 AM (in response to Владимир Фасюра)Set analysis is evaluated once per chart. When you do Max(Period) in the chart, it calculates the overall max and not max by your dimension. Would you be able to share you input file or some dummy data to show how this can work?

Re: In one dimension, the amount of pull of the maximum sum value of another dimension.
Владимир Фасюра Aug 18, 2016 8:11 AM (in response to Sunny Talwar )1st  the problem is solved!!
now  explanation:
when I realized that I can not quickly solve the problem, I have prepared a dummyfile to find the right solutions on lowsize data. and then all calculations are carried out exactly in it..
and at this moment I somehow incorrectly uploaded data to that dummy from test file.. so.. all cells uploaded as non"null" values.
so FirstSortedValue(Aggr(Sum(Sales), Period, Product), Aggr(Period, Period, Product)) not worked properly
today:
I'm was going to send you dummydata, but decided to first basically check my primary workdata file
And it worked!
As it turned out, I had already used the same expression, which you gave to me(in testfile) .. but I forgot that i need to use in testfile the condition if(Sales>0,Period)
so.. for corrupted data useful the following code
FirstSortedValue(Aggr(Sum(Sales), Period, Product), Aggr(if(Sales>0,Period), Period, Product))
last question: i cant understand how to share noncommercial examples of qlickview apps(i mean without "attempt to restore") =(..
so.. *csv and *.xls to share (in next tasks if needed)


