topic Re: Show only Dimension = max(Dimension) in QlikView

Show only Dimension = max(Dimension)

cbaqir — Thu, 21 Sep 2017 16:28:49 GMT

I want to only show rows where PRIMARY_DECISION_AGENDA_DATE = max(PRIMARY_DECISION_AGENDA_DATE) but this is not working. If I select Suppress Null, nothing shows up at all.

= Aggr(IF(Rank(Date(if(match(PRIMARY_DECISION_AGENDA_DATE,max(PRIMARY_DECISION_AGENDA_DATE)>0,PRIMARY_DECISION_AGENDA_DATE))), 0) = 1,PRIMARY_DECISION_AGENDA_DATE), GOV_DECISION_BODY, REQUEST_REGION, DETECT_BY, CUR_STATUS,DEFECT_ID, PRIMARY_DECISION_AGENDA_DATE)

Thoughts?

Re: Show only Dimension = max(Dimension)

sunny_talwar — Thu, 21 Sep 2017 16:32:46 GMT

May be try this:

=Aggr(IF(Rank(Date(if(match(PRIMARY_DECISION_AGENDA_DATE, max(TOTAL <GOV_DECISION_BODY, REQUEST_REGION, DETECT_BY, CUR_STATUS, DEFECT_ID> PRIMARY_DECISION_AGENDA_DATE) > 0, PRIMARY_DECISION_AGENDA_DATE))), 0) = 1, PRIMARY_DECISION_AGENDA_DATE), GOV_DECISION_BODY, REQUEST_REGION, DETECT_BY, CUR_STATUS, DEFECT_ID, PRIMARY_DECISION_AGENDA_DATE)

Re: Show only Dimension = max(Dimension)

cbaqir — Thu, 21 Sep 2017 16:38:23 GMT

Nope. I think there's an issue with the field's date format.

Re: Show only Dimension = max(Dimension)

sunny_talwar — Thu, 21 Sep 2017 16:39:59 GMT

Can you show an image of list box for PRIMARY_DECISION_AGENDA_DATE

Re: Show only Dimension = max(Dimension)

cbaqir — Thu, 21 Sep 2017 16:40:47 GMT

Re: Show only Dimension = max(Dimension)

sunny_talwar — Thu, 21 Sep 2017 16:42:33 GMT

Not seeing any issues with the date.... may be I don't really know what you goal is

Re: Show only Dimension = max(Dimension)

cbaqir — Thu, 21 Sep 2017 16:45:03 GMT

I want the chart to only show rows where the PRIMARY_DECISION_AGENDA_DATE = max(PRIMARY_DECISION_AGENDA_DATE)

Re: Show only Dimension = max(Dimension)

sunny_talwar — Thu, 21 Sep 2017 16:46:06 GMT

What is all the other stuff with Rank and stuff? What is the goal of that?

Re: Show only Dimension = max(Dimension)

cbaqir — Thu, 21 Sep 2017 16:47:12 GMT

They are probably not necessary and I was over-complicating it.

Re: Show only Dimension = max(Dimension)

sunny_talwar — Thu, 21 Sep 2017 16:56:54 GMT

May be this

If(PRIMARY_DECISION_AGENDA_DATE = Max(TOTAL PRIMARY_DECISION_AGENDA_DATE), PRIMARY_DECISION_AGENDA_DATE)

Re: Show only Dimension = max(Dimension)

cbaqir — Thu, 21 Sep 2017 16:59:02 GMT

Thanks!