Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ravishinge
Contributor

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

Re: Hello Guys, I have a question regarding date functions ?

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

ravishinge
Contributor

Re: Hello Guys, I have a question regarding date functions ?

Hello kaushik,

Thanks a lot . I got it

Regards,

Ravi

Community Browser