Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Calculating on a subset of a table

Hi guys!

My first post here, problaly not the last. And hope to contribute in a while

Consider this table:

Capture.PNG

I want to calculate and show the Percentage only for the latest (max(Dato)) date. How can I accomplish this?

Best regards

Trond Erik

1 Solution

Accepted Solutions
calvindk
Contributor III

Re: Calculating on a subset of a table

If(Date=Max(Total Date), Expression ))

3 Replies
calvindk
Contributor III

Re: Calculating on a subset of a table

If(Date=Max(Total Date), Expression ))

Not applicable

Re: Calculating on a subset of a table

As an expression or calculated dimension?

calvindk
Contributor III

Re: Calculating on a subset of a table

As an expression.