Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trend Line Chart

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)

4 Replies
Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

Sorry, I am on vacation. Hope the Community will help you. Best Regards, Philipp

Not applicable
Author

Its ok ,i will take help from commumity

Thanks Philip