Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Regarding charts

Hi  this is mahesh  i had Query on line chart  options   for example  i have data like this

  

clockingjan, 16dec, 15
clocking time93%89%
non clocking time30%39%

i want output same as like this can u  share snap shots i

Capture.PNG

i had tried    by using line chart  i got  output like this   but  i want output same as  above can u  share snapshots please urgent thank you in advance

imag2.PNG

4 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

It looks like you need to swap the two dimensions (promote one of them).

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy and Austin, TX!

Anonymous
Not applicable
Author

Could pls explain  it, as iam new to qlikview . I need output as fig1. Thankyou

Anonymous
Not applicable
Author

As Oleg suggested promote the bottom dimension :

  • Right Click your chart
  • Properties
  • Dimension tab
  • Select your bottom [2nd] dimension
  • <Click> the Promote button
amayuresh
Creator III
Creator III

Try this,

Script:

CrossTable(Month, Percentage)

LOAD clocking,

     [jan, 16],

     [dec, 15]

FROM

(ooxml, embedded labels, table is Sheet4);

Output:

1.PNG

Dimension:

Month, Clocking

Expression: =Percentage