Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

LINE CHART WITHOUT DIMENSION

Hi Guys!

I'm new to Qlicksense. I would like to make a line chart but I don't have the dimension.

On my DB I have the following columns:

municipality, water investment 2017,water investment 2018, water investment 2019|sewer investment 2017,sewer investment 2018,sewer investment 2019| depuration investment 2017, depuration investment 2018, depuration investment 2019.

I would a linear chart that has three lines on the Y axis (water,sewer and depuration), and I would 3 years (2017,2018,2019) on the X axis. 

I have the municipality because on my dashboard I have a filter box to select a specific municipality.

Thanks for the help!

 

2 Solutions

Accepted Solutions
Creator II
Creator II

I think that you need to look into the CrossTable() function to translate your Data into usable Yearly Data Points. 

 

ie. your finished table should look like this:

 

MunicipalityDimensionYearValue
Londonwater investment2017xxxx
Londonwater investment2018xxxx
Londonwater investment2019xxxx
Londonsewer investment2017xxxx
Londonsewer investment2018xxxx
Londonsewer investment2019xxxx
Londondepuration investment2017xxxx
Londondepuration investment2018xxxx
Londondepuration investment2019xxxx

View solution in original post

May be use Trellis Chart after your model ready?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Creator II
Creator II

I think that you need to look into the CrossTable() function to translate your Data into usable Yearly Data Points. 

 

ie. your finished table should look like this:

 

MunicipalityDimensionYearValue
Londonwater investment2017xxxx
Londonwater investment2018xxxx
Londonwater investment2019xxxx
Londonsewer investment2017xxxx
Londonsewer investment2018xxxx
Londonsewer investment2019xxxx
Londondepuration investment2017xxxx
Londondepuration investment2018xxxx
Londondepuration investment2019xxxx

View solution in original post

May be use Trellis Chart after your model ready?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post