Canonical Date Expression

pkpandey · ‎2016-03-21

Hi All

I have two dates Start_Date and Completed_Date and I am using canonical date in my data model. My question is how to write a set expression to calculate amount for a selected period. Say user has selected period start as 05/05/2015 and period end as 15/05/2015.

What should be my set analysis to sum the amount based on the Start_Date and sum of Size based on the Completed_Date.

pkpandey · ‎2016-03-21

On Mon, 21 Mar 2016 14:43:52 +0530 jagan mohan rao appala wrote

Canonical Date Expression

reply from jagan mohan rao appala in QlikView Deployment - View the full discussion

Can you attach sample file? Is Canonical date and date(Min(CanonicalDate)) are in same date format?

Regards,Jagan.

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in QlikView Deployment by email or at Qlik Community

Following Canonical Date Expression in these streams:

Inbox

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

Web Clients