Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
JoseGarcia
Creator II
Creator II

Chart help

HI there, 

I have a table that looks just  like to what I included below.
I would like to get a Line chart that gives me a curve of costs for each month.
I cannot figure out how to add Date on the Dimension and sum value for the period as a measure.

Apr-20May-20Jun-20Jul-20Aug-20Sep-20Oct-20Nov-20Dec-20Jan-21
£100£101£102£103£104£105£106£107£108£109
£50£50£50£50£50£50£50£50£50£50
£25£25£25£25£25£25£25£25£25£25


Could anyone help?

Thanks a million.

Jose

Labels (1)
1 Solution

Accepted Solutions
PradeepK
Creator II
Creator II

This is most common with excel based data sources. Try to use CROSS TABLE load work-with-cross-tables 

View solution in original post

1 Reply
PradeepK
Creator II
Creator II

This is most common with excel based data sources. Try to use CROSS TABLE load work-with-cross-tables 

View solution in original post