topic Re: Values to repeat in a chart straight table in QlikView

Values to repeat in a chart straight table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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-16	6 092 970
Sep-16	6 862 879
Oct-16	6 530 097
Nov-16	6 673 340
Dec-16	6 219 913
Jan-17	6 598 741
Feb-17	6 280 318
Mar-17	6 725 122
Apr-17	6 395 875
May-17	6 460 487
Jun-17	6 616 062
Jul-17	6 426 271
Total	77 882 076

Ideal Answer

Calendar Month	Sales	Lowest Month Sales
Aug-16	6 092 970	6 092 970
Sep-16	6 862 879	6 092 970
Oct-16	6 530 097	6 092 970
Nov-16	6 673 340	6 092 970
Dec-16	6 219 913	6 092 970
Jan-17	6 598 741	6 092 970
Feb-17	6 280 318	6 092 970
Mar-17	6 725 122	6 092 970
Apr-17	6 395 875	6 092 970
May-17	6 460 487	6 092 970
Jun-17	6 616 062	6 092 970
Jul-17	6 426 271	6 092 970
Total	77 882 076

Re: Values to repeat in a chart straight table

tresB — Wed, 15 Nov 2017 05:35:42 GMT

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

Re: Values to repeat in a chart straight table

luismadriz — Wed, 15 Nov 2017 05:56:58 GMT

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

Re: Values to repeat in a chart straight table

Anonymous — Wed, 15 Nov 2017 06:07:11 GMT

Hi Treseco

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

Kind regards

Nayan

Re: Values to repeat in a chart straight table

Anonymous — Wed, 15 Nov 2017 06:08:19 GMT

Hi Luis

Thank you fro your reply.

It is the sales of the oldest month.

Kind regards

Nayan

Re: Values to repeat in a chart straight table

luismadriz — Wed, 15 Nov 2017 06:11:06 GMT

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

Re: Values to repeat in a chart straight table

Anonymous — Wed, 15 Nov 2017 06:18:53 GMT

Thank you Luis. It worked.

Kind regards

Nayan

Re: Values to repeat in a chart straight table

prma7799 — Wed, 15 Nov 2017 06:28:13 GMT

PFA...