Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kellymcgrady
Contributor

Max code not working

I need to get the max last modified Time, Max() command is not working and pulling all of the information.

Tags (2)
1 Solution

Accepted Solutions
kellymcgrady
Contributor

Re: Max code not working

So I found out that the QVD is turning my dates into garbage when I try to format them. In the csv my data is fine.

4 Replies
MVP
MVP

Re: Max code not working

In the script or front end?

rittermd
Honored Contributor

Re: Max code not working

Can you provide the code and some background on the data you are working with?

kellymcgrady
Contributor

Re: Max code not working

I'm using a giant denormalized qvd and this last modified date is  connected to 40 tables. I found a work around but I don't understand what happened in the first place.

kellymcgrady
Contributor

Re: Max code not working

So I found out that the QVD is turning my dates into garbage when I try to format them. In the csv my data is fine.