Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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...

Labels (1)
1 Solution

Accepted Solutions
MarcoWedel
MVP
MVP

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
Partner - Champion III
Partner - Champion III

See attached qvw


talk is cheap, supply exceeds demand
sunny_talwar
MVP
MVP

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

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!