Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

roee1983
New Contributor III

Create a Line chart

Hi all,

I have been trying to create a  line chart just like in excel.

please find attched file which include example which i need to create in qlikview.

Thanks

Roee

1 Solution

Accepted Solutions

Re: Create a Line chart

Hi,

another example with discrete dimension axis in descending order might be:

QlikCommunity_Thread_286507_Pic1.JPG

hope this helps

regards

Marco

14 Replies

Re: Create a Line chart

Excel may have Bunch of Designs but not with Qlikview. If you are good in JS go and use extensions for a while.

In Qlik, We have filled plot style perhaps you may try that

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
roee1983
New Contributor III

Re: Create a Line chart

Hi;

can you guide me the way to make a similar chart?

Thanks

Re: Create a Line chart

The similar chart may not possible using Qlik, But could be there is work around. Let me invite marcowedel‌ to help

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pradosh_thakur
Honored Contributor II

Re: Create a Line chart

How about this. with slight modification i guess we can achieve what you exactly want 

Capture.PNG

Learning never stops.

Re: Create a Line chart

Looks good, Have you enabled the option "Continuous" for Dimension and Disable "Forced 0" for expression??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pradosh_thakur
Honored Contributor II

Re: Create a Line chart

yes Anil.

Learning never stops.

Re: Create a Line chart

But, Continuous won't work for Alpha numeric in X-Axis..

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
pradosh_thakur
Honored Contributor II

Re: Create a Line chart

Yes but the data he has given he has taken the rowno in x axis or that's what i understood. So it will work in this case.

not sure but with alphanumberic value in x axis. dual() can help for making it continuous.

Learning never stops.

Re: Create a Line chart

Hi,

another example with discrete dimension axis in descending order might be:

QlikCommunity_Thread_286507_Pic1.JPG

hope this helps

regards

Marco