Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

set analysis in calculated dimension

I wat to create calculated dimension  ,with set analysis expression

display the value of column x for the max date


Capture.PNG

1 Solution

Accepted Solutions
MVP
MVP

Re: set analysis in calculated dimension

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

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

8 Replies
MVP
MVP

Re: set analysis in calculated dimension

May be like:

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

MVP
MVP

Re: set analysis in calculated dimension

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

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

Re: set analysis in calculated dimension

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

souadouert
Contributor III

Re: set analysis in calculated dimension

I want show always the lastest value

Re: set analysis in calculated dimension

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

souadouert
Contributor III

Re: set analysis in calculated dimension

y are raight sunny

Re: set analysis in calculated dimension

So, is the issue resolved now? I am confused

souadouert
Contributor III

Re: set analysis in calculated dimension

Yes sunny thank youuuu

Community Browser