Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik Developers
how to get previous year date Like my expression is below. I want the date should change automatic. example the date in the expression is 10/01/2015 if i come at next month the date should be 11/01/2016
expression:
=count({<Kit={">=07/01/2015"}>} ID)
label of the expression should display nov 2015
Total kits received from oct 2015
This should convert to nov 2015
Need to display 24 weeks the week should start on sunday. Below is the expression.
=if(Master_WeekStart>='04/03/16',Master_WeekStart)
Can someone help me please.
Thanks
Anil
May be this:
=Count({<Kit = {"$(='>=' & Date(MonthStart(Today()), 'MM/DD/YYYY'))"}>} ID)
If you need previous year, you can try this:
=Count({<Kit = {"$(='>=' & Date(MonthStart(Today(), -12), 'MM/DD/YYYY'))"}>} ID)
Hi Sunny
Thanks for the response
i have the below expression
expression:
=count({<Kit={">=07/01/2015"}>} ID)
The expression what you provided is displaying zero. i want the date to be automated if i go to next month.
Thanks
Anil
what is the next month? 08/01/2015?
yes.
May be this:
=Count({<Kit = {"$(='>=' & Date(MonthStart(Today(), -15), 'MM/DD/YYYY'))"}>} ID)
I Tried your expression but i am getting zero values. If possible check ur mobile
Thanks
Anil
Thanks Sunny Bro
Its working fine.
I want to display 24 weeks the week should start on sunday. Below is the expression.
=if(Master_WeekStart>='04/03/16',Master_WeekStart). Can you help me please.
Thanks
Anil
24 Weeks means, You want to show starting from Year to 24 weeks / What?