Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sayyam005
New Contributor

Aggregate Dimension over a date

I have two dimensions Key and Date and one measure sales.Each key has one date and  null values. The problem is sales data is available only for null value.

KeyDateSales
1011-09-2017_
101_232
101_321
102_654
102_342
1021-10-2017_

I want to show both date(Excluding nulls) and max(sale) for the keys in the table.

The issue is if i filter null values for date i get null for max (sales) because sales data is only available for null dates,How do i show both max(sales) and date together in table.

Can i do some 'aggregation' on date over key so that i dont exclude null dates(maybe something like Aggr(Date(Max(Date)),Key)  )??

1 Reply

Re: Aggregate Dimension over a date

Create a Straight Table


Dimension

1) Key

2) =Aggr(Max(Date),Key)

Expression

Max(TOTAL <Key> Sales)

Community Browser