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: 
Anonymous
Not applicable

Line Chart

Hello Expert!

my data

TransactionNumber    Agency   Amount

                             1       AA        500

                             2       BB        300

                             3       CC       466

                             4       GG       800

                             5       AA        300

                             6       DD        367

                             7       EE        999

                             8       EE        1035

                             9       FF        100

                           10       GG       200

                            11      BB        700

                            12      CC        1100

                            13      AA        300

I would like to create a line chart  with X axis as Agency and Y axis as sum each agency spend.

How do I input my dimension and measure?

Thanks!

1 Solution

Accepted Solutions
surendraj
Specialist
Specialist

Take dimension as Agency and expression as a Sum(Amount)

Capture.PNG

It will have x--axis  as Agancy and Y-- axis as Amount.

View solution in original post

3 Replies
surendraj
Specialist
Specialist

Take dimension as Agency and expression as a Sum(Amount)

Capture.PNG

It will have x--axis  as Agancy and Y-- axis as Amount.

vinieme12
Champion III
Champion III

You might want to do some reading and watch some tutorial videos on YouTube

QV Tutorial.pdf

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Thanks!

Looks like is my data issue that cause my chart to look weird, wonder what is wrong.

But thks for the help!