Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
romain_p
Contributor II
Contributor II

Adding Bases on axis

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:

Capture.JPG

Variables are:

'Month'

'Sales'

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

Capture2.JPG

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...

1 Solution

Accepted Solutions
MarcoWedel

Hi,

another solution could be:

QlikCommunity_Thread_148206_Pic1.JPG

QlikCommunity_Thread_148206_Pic2.JPG

QlikCommunity_Thread_148206_Pic3.JPG

hope this helps

regards

Marco

View solution in original post

8 Replies
fkeuroglian
Partner - Master
Partner - Master

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

Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand
sunny_talwar

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

Best,

S

romain_p
Contributor II
Contributor II
Author

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...

romain_p
Contributor II
Contributor II
Author

Yes, by base I mean Total.

romain_p
Contributor II
Contributor II
Author

Ok, so you're using combined charts.

I have to test this possibility...

MarcoWedel

Hi,

another solution could be:

QlikCommunity_Thread_148206_Pic1.JPG

QlikCommunity_Thread_148206_Pic2.JPG

QlikCommunity_Thread_148206_Pic3.JPG

hope this helps

regards

Marco

romain_p
Contributor II
Contributor II
Author

Thanks a lot Marco, it works!