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: 
paulyeo11
Master
Master

How to make my stack chart change to line chart ?

Hi All

May i know how to make the chart 1 , Now is stack bar chart . i need it display none stack bar chart , so that i can view the exp trend by month.

Meaning the bar only have one color , so that i can change to line chart.

Paul

9 Replies
paulyeo11
Master
Master
Author

Enclosed my QV Doc

Anonymous
Not applicable

Hi Paul,

If it's currently stacked it means that you either have 2 dimensions or more than 1 expression.

If you have 2 dimensions, you can remove the second dimension and if needed, modify your expression to calculate the expected result.

If you have 1 dimension but more than one expression, combine your expressions to one to calculate the expected result.

If you have an example file, it'll be easier to advice on what would be the easiest way.

PrashantSangle

Hi,

Use Combo chart ->

then select 1 expr as Line

and Other is Bar in Expression tab

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
pratap6699
Creator
Creator

after prepare bar stock chart then go to general-->select line chart

it will display the both expressions in line chart but change the presentation with 3D look

paulyeo11
Master
Master
Author

Hi Johanne

Thank you for your advise, my QV doc is attach above.

paulyeo11
Master
Master
Author

Hi Sir

I have change to line chart , after change to 3D , it still display not right.

ankit777
Specialist
Specialist

Hi,

You have two dimensions in your chart. If you want to remove the stack, then remove second dimension which is

=if(Seq>1 and EXP_P='Y' AND  len(Trim($(ColumnDim8)))>1,$(ColumnDim8) & ' ' )

After this you can change the bar chart to a line chart.


paulyeo11
Master
Master
Author

Hi Ankit

Any idea how can i remove the 2nd dimension ?

Paul

ankit777
Specialist
Specialist

go to dimensions, click on second dimension(which is a calculated one) and click remove.