topic Re: Create a Line chart in QlikView

Create a Line chart

roee1983 — Tue, 02 Jan 2018 07:50:33 GMT

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

Re: Create a Line chart

Anil_Babu_Samineni — Tue, 02 Jan 2018 08:00:14 GMT

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

Re: Create a Line chart

roee1983 — Tue, 02 Jan 2018 11:04:09 GMT

Hi;

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

Thanks

Re: Create a Line chart

Anil_Babu_Samineni — Tue, 02 Jan 2018 12:33:47 GMT

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

Re: Create a Line chart

pradosh_thakur — Tue, 02 Jan 2018 13:34:52 GMT

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

Re: Create a Line chart

Anil_Babu_Samineni — Tue, 02 Jan 2018 13:41:17 GMT

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

Re: Create a Line chart

pradosh_thakur — Tue, 02 Jan 2018 13:44:57 GMT

yes Anil.

Re: Create a Line chart

Anil_Babu_Samineni — Tue, 02 Jan 2018 13:51:31 GMT

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

Re: Create a Line chart

pradosh_thakur — Tue, 02 Jan 2018 14:06:22 GMT

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.

Re: Create a Line chart

MarcoWedel — Tue, 02 Jan 2018 18:09:23 GMT

Hi,

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

hope this helps

regards

Marco

Re: Create a Line chart

pradosh_thakur — Tue, 02 Jan 2018 18:22:00 GMT

Hi Macro

This is even better. Can you please let me know how to create the discrete dimension axis? Unable to open the qvw document due to restriction .

thank you ..

Re: Create a Line chart

Anil_Babu_Samineni — Tue, 02 Jan 2018 18:24:38 GMT

Quiet 2 similar, But he used like below.

Re: Create a Line chart

MarcoWedel — Tue, 02 Jan 2018 19:37:34 GMT

Hi,

another thing I did was to select the "show all bars" setting (to enable it I had to temporarily switch to bar chart before applying this setting and back to line chart afterwards).

hope this helps

regards

Marco

Re: Create a Line chart

johnca — Tue, 02 Jan 2018 20:11:12 GMT

"(to enable it I had to temporarily switch to bar chart before applying this setting and back to line chart afterwards)"

I discovered this neat trick some time back too. Not sure if it was the exact same trick, but I too had to select one chart type, create my options, then revert back to get what I wanted.

Re: Create a Line chart

MarcoWedel — Tue, 02 Jan 2018 20:41:38 GMT

I'm not sure what might be the reason for this behaviour, but maybe Qlik can shed some light on it?

hic‌

Marco