Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Re: How to display /sort year in a line graph

Hi,

I have a data set that has financial information from 1980 to 2018 I only want to create a line graph showing the information from 2010 - 2018. how do i achieve this please assist.

Thank you

Regards

Saran

Tags (1)
14 Replies

Re: How to display /sort year in a line graph

Use below as dimension

IF(Year >= 2010,Year)

Tick Suppress When Value is Null

rospigliosi
Contributor

Re: How to display /sort year in a line graph

... and sort as Numeric value

Not applicable

Re: How to display /sort year in a line graph

it is still displaying all years

Not applicable

Re: How to display /sort year in a line graph

I have tried  this but there is an issue with the function

isorinrusu
Contributor III

Re: How to display /sort year in a line graph

Make sure you use the equal sign in the dimension and that your year dimension is called 'Year':

=IF(Year >= 2010,Year)


Upload a screenshot of your dimension if it does not work.


Regards,

Sorin.

Not applicable

Re: How to display /sort year in a line graph

PAYMENT.PNG

Not applicable

Re: How to display /sort year in a line graph

=IF(deposit_date >= 2015,deposit_date)

I used this but it is still displaying data from 1973 ..

i need to show data from 2010 only

isorinrusu
Contributor III

Re: How to display /sort year in a line graph

Saran, you need to convert the deposit_date to Year format. Your dimension then will be:

=IF(Year(deposit_date) >= 2015,deposit_date)

Not applicable

Re: How to display /sort year in a line graph

deposit_datecurrency_idamount_usd
10/12/2011
167397142
10/12/1999
167401276
10/12/1975
167325019
10/12/2015
167108586
10/12/2015
16734519
10/12/2015
167559
10/12/201516770049.03
09/12/2015167212031.56
08/12/2016167209878.95
07/12/201129454545.45

    This is a sample of the data i have

Community Browser