Discussion board where members can get started with Qlik Sense.
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.
Use below as dimension
IF(Year >= 2010,Year)
Tick Suppress When Value is Null
... and sort as Numeric value
it is still displaying all years
I have tried this but there is an issue with the function
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.
=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
Saran, you need to convert the deposit_date to Year format. Your dimension then will be:
=IF(Year(deposit_date) >= 2015,deposit_date)
This is a sample of the data i have