Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
msapre
Contributor II
Contributor II

Issues converting a pivot table to a line chart

I'm having some issues with converting a pivot table into a line chart. I'm trying to display the % change quarter over quarter for a variable (TOTAGLN), one line displayed for the variable COMMERCIAL_BANK = 0, and one for COMMERCIAL_BANK = 1.

I was able to get the correct data into a pivot table using this formula:

(SUM(TOTAGLN) -Above(SUM(TOTAGLN)))/Above(SUM(TOTAGLN))*100.

When I put this formula into the pivot table, and add COMMERCIAL_BANK as a column, it gives me the correct values.

msapre_0-1741888094031.png

But when I convert it into a line chart, it doesn't display 2 different lines for COMMERCIAL_BANK, even if I've defined it as the line variable.

msapre_1-1741888141720.png

 

And also, the values are complete off. Please let me know how to fix this so the line chart displays the correct values.

Thanks!

Labels (4)
1 Reply
Buzze
Contributor II
Contributor II

Hi, adding a second dimension to a line chart will only make it an alternative dimension. So in your case it can either display year or commercial bank. If you want multiple lines, you have to duplicate your expression and add a filter for each commercial bank through set analysis.