topic Re: set analysis in calculated dimension in QlikView

set analysis in calculated dimension

souadouert — Tue, 20 Feb 2018 09:46:49 GMT

I wat to create calculated dimension ,with set analysis expression

display the value of column x for the max date

tresB — Tue, 20 Feb 2018 09:53:18 GMT

May be like:

Only(Total {<Date={'$(=Date(max(Date)))'}>} Column)

tresB — Tue, 20 Feb 2018 09:55:44 GMT

Well, if I go with sample screen shot, try like:

=Date(Max(total Date#(DATE,'YYYYMM')), 'YYYYMM')

sunny_talwar — Tue, 20 Feb 2018 09:58:36 GMT

C6 300 is on 201705, why would you be seeing that?

souadouert — Tue, 20 Feb 2018 10:13:14 GMT

I want show always the lastest value

sunny_talwar — Tue, 20 Feb 2018 12:13:13 GMT

But C6's latest value is on 201705 and not 201706? how are you seeing this next to 201706?

souadouert — Wed, 21 Feb 2018 10:49:12 GMT

y are raight sunny

sunny_talwar — Wed, 21 Feb 2018 12:06:29 GMT

So, is the issue resolved now? I am confused

souadouert — Wed, 21 Feb 2018 12:39:33 GMT

Yes sunny thank youuuu