Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I am creating Trend Line Chart with Year , Month , Week , Day .
I am unable to get output ,please help me with Expression
But i want output according to below link .
Please refer the link
http://www.xe.com/currencycharts/?from=USD&to=CAD&view=1Y
For Week eg : Today's date is 17-04-2017 , Line chart will show data from 17-04-2017 to 10-04-2017,
If there is no data for some date in this week , It should show the date with value zero (like master calendar)
For Month eg : It should show data as each date from 17-03-2017 to 17-04-2017.
Thanks ,
Pankaj Bhalekar Cheers (beer)
Hi,
there is a good example from Michael Tarollo incl. Sales Analysis.qvf and MasterCalendar.
Understanding the Master Calendar (video)
also see this "Show Zero values" Qlik Sense - Bar charts with constant time line - even with no data
Best Regards,
Philipp
Please mark the appropriate replies as CORRECT / HELPFUL so other members know that your question(s) has been answered to your satisfaction.
Hi ,
Thanks for reply ,but i have already saw that video and i am able to achieve the functionality such as Line charts with constant time line - even with no data
I need data (if for week i need last 7 days data ,for month i need last 30 days data )
I appreciate your help
Sorry, I am on vacation. Hope the Community will help you. Best Regards, Philipp
Its ok ,i will take help from commumity
Thanks Philip