topic Re: Adding Bases on axis in QlikView

Adding Bases on axis

romain_p — Tue, 13 Jan 2015 10:55:02 GMT

Hello,

I'm brand new in Qlikview and I'd like to ask you a question.

Is it possible to add bases on axis?

For example. I have this table:

Variables are:

'Month'

'Sales'

And I would like to obtain something like that on Qlik:

As you can see, there is bases under each month...

I hop I've been clear enough, thanks a lot for those how will read and / or help.

PS: And sorry for my english, It is not my mother tongue...

Re: Adding Bases on axis

fkeuroglian — Tue, 13 Jan 2015 11:26:03 GMT

Hi Romain

you have to create a CROSS TABLE in qlikview

see this video to explain and good luck

Fernando

Loading Cross Tables

The Crosstable Load

Re: Adding Bases on axis

Gysbert_Wassenaar — Tue, 13 Jan 2015 11:33:29 GMT

See attached qvw

Re: Adding Bases on axis

sunny_talwar — Tue, 13 Jan 2015 11:43:15 GMT

By 'Base' you mean you want to show the total below the month?

Best,

Re: Adding Bases on axis

romain_p — Tue, 13 Jan 2015 16:43:07 GMT

Thanks,

I'm watching your video but it seems that it is not excatly what I'm looking for. What I showed was just an example, I had a real DB behind it, not a table like that...

Re: Adding Bases on axis

romain_p — Tue, 13 Jan 2015 16:43:33 GMT

Yes, by base I mean Total.

Re: Adding Bases on axis

romain_p — Tue, 13 Jan 2015 16:44:05 GMT

Ok, so you're using combined charts.

I have to test this possibility...

Re: Adding Bases on axis

MarcoWedel — Tue, 13 Jan 2015 17:15:35 GMT

Hi,

another solution could be:

hope this helps

regards

Marco

Re: Adding Bases on axis

romain_p — Tue, 13 Jan 2015 17:53:22 GMT

Thanks a lot Marco, it works!