Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is the expression for taking month wise analysis of quantity in a line chart when the date is given in numerical format??

what is the expression for taking month wise analysis of quantity in a line chart when the date is given in numerical format??

6 Replies
sunny_talwar

Can you share what values do you have for date?

Not applicable
Author

i am having quantity values for various dates  eg: 19/04/2016 20/04/2016... 1/05/2016, 23/05/2016

there are various dates i need the quantity for the each sepearte month

sunny_talwar

I am still not 100% sure I understand your scenario. Can you may be share few rows of your raw data

Anonymous
Not applicable
Author

if i understand correct you Need to define a Dimension as month(yourdatefield)

you may Format the month to ypur requirements

month(yourdatefield,'MMM') will Show you May, Jun etc. for your datedimension

the values will be automatically presented monthwise

manucamon
Specialist III
Specialist III

Hi maikanta,

With Month() you will get the month from a date, don't worry if Date is in numerical or date format.

With MonthYear() you will get the month with the year.

All date functions work equally in numeric format or date format.


Regards!

iahamedabdullah
Partner
Partner

Give a try with this Calculated Dimension: Date(Left(NUM(Date Field),5),'MMM')