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: 
Anonymous
Not applicable

Values to repeat in a chart straight table

Hi

I want a value to be repeat in a column.  So in my table below, I want for the value for Min Month (ie Aug 16) which is 6 092 970 to be repeated in another column. (See 2nd table below for ideal answer).

For simplicity, My dimension is Calendar Month and my Expression is Sum(Sales).

Please note that Min Month is dynamic and not specifically relating to Aug 16

Kind regards

Nayan

 

Calendar

Month

Sales
Aug-166 092 970
Sep-166 862 879
Oct-166 530 097
Nov-166 673 340
Dec-166 219 913
Jan-176 598 741
Feb-176 280 318
Mar-176 725 122
Apr-176 395 875
May-176 460 487
Jun-176 616 062
Jul-176 426 271
Total77 882 076

Ideal Answer

Calendar MonthSalesLowest Month Sales
Aug-166 092 9706 092 970
Sep-166 862 8796 092 970
Oct-166 530 0976 092 970
Nov-166 673 3406 092 970
Dec-166 219 9136 092 970
Jan-176 598 7416 092 970
Feb-176 280 3186 092 970
Mar-176 725 1226 092 970
Apr-176 395 8756 092 970
May-176 460 4876 092 970
Jun-176 616 0626 092 970
Jul-176 426 2716 092 970
Total77 882 076
1 Solution

Accepted Solutions
luismadriz
Specialist
Specialist

Then it could be this assuming that your month is has a Dual value in the script

Sum(Total {<[Calendar Month]={$(=Min([Calendar Month]))}>} Sales)

I hope this helps,

Luis

View solution in original post

7 Replies
tresesco
MVP
MVP

FirstSortedValue( Total Aggr(Sum(Sales), [Calendar Month]), [Calendar Month])

luismadriz
Specialist
Specialist

Hi,

I would have thought of something like this:

$(=Min(Aggr(Sum(Sales),[Calendar Month])))

Is the value in red the lowest monthly sales, or is it the monthly sales of the oldest month?

Cheers,

Luis

Anonymous
Not applicable
Author

Hi Treseco

Thank you for your reply.  I've applied your formula, however I get a blank.

Kind regards

Nayan

Anonymous
Not applicable
Author

Hi Luis

Thank you fro your reply.

It is the sales of the oldest month.

Kind regards

Nayan

luismadriz
Specialist
Specialist

Then it could be this assuming that your month is has a Dual value in the script

Sum(Total {<[Calendar Month]={$(=Min([Calendar Month]))}>} Sales)

I hope this helps,

Luis

Anonymous
Not applicable
Author

Thank you Luis.  It worked.

Kind regards

Nayan

prma7799
Master III
Master III

PFA...