Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hello Guys, I have a question regarding date functions ?

I basically have a column in my data sheet which has all Dates in the format of (MM/DD/YY) . I need to segregate years such as 2014, 2015, 2016... so on and I need to display related values under these years . How I do extract these dates ? And what chart or expression I should be using in order to do it .  I need something like this to represent .

201420152016
x valuesy valuesz values
2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Assuming you are getting the Date and the Values i.e (XYZ) from same table, you should try below script and expressions.

Script:

Load *,Year(Date) as Year

From xyz;

Now on frontend create a pivot table and add Column as year and Sum("Valuefield") (Name of the field which has the value) as expression.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

Hello kaushik,

Thanks a lot . I got it

Regards,

Ravi