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: 
AriIt
Contributor II
Contributor II

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
Anil_Babu_Samineni

May be use Trellis Chart after your model ready?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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

AriIt
Contributor II
Contributor II
Author

I solved this problem: I created a personalized dimension and measure. 

Dimension:

=ValueList('2017','2018','2019')

Measure:

=If(ValueList('2017','2018','2019')='2017', Sum([Water investment 2017]),

If(ValueList('2017','2018','2019')='2018', Sum([Water investment 2018]),

If(ValueList('2017','2018','2019')='2019', Sum([Water investment 2019]))))

and then another 2 measures for sewer and depuration.

 

View solution in original post

3 Replies
tm_burgers
Creator III
Creator III

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
Anil_Babu_Samineni

May be use Trellis Chart after your model ready?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
AriIt
Contributor II
Contributor II
Author

I solved this problem: I created a personalized dimension and measure. 

Dimension:

=ValueList('2017','2018','2019')

Measure:

=If(ValueList('2017','2018','2019')='2017', Sum([Water investment 2017]),

If(ValueList('2017','2018','2019')='2018', Sum([Water investment 2018]),

If(ValueList('2017','2018','2019')='2019', Sum([Water investment 2019]))))

and then another 2 measures for sewer and depuration.