Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 date field: Date_Received and Date_Invoiced in The Same Table.
I want , if i i choose one month ( for example March 2014 ) i get the Stock till End of Month ( 31/03/2014 ).
the customer provide me this Condition: Date_Received < Number of Car <Date_Invoiced.
So i have to put this Condition in Expression. How Can i do it ?
And From with Field i Have to Select the Month ( Dimension ) Date_Received or Date_Invoiced, i Mean Which one will be the Main Date ?
Thanks
Hi,
Check this post
http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date
Regards
ASHFAQ