Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
t_vijay_qlik
Contributor III
Contributor III

Re:Sales Analysis

Hi all,

can any help in  the sales analysis for the data files attached

i got some errors

capture1

sales performance

data for productsubcategory is not displayed

Caputer2

How to increase the scale the sum(salesamount) axis

Capture3

While displaying the KPI's negative values are being displayed

6 Replies
sunny_talwar

For 1, uncheck 'Include Zero Values' under add-ons -> Data Handling

Capture.PNG

sunny_talwar

What do you mean "increase the scale the sum(salesamount) axis"?

sunny_talwar

May be online gross profit is negative and that is why we see a negative number? I see Sales of 57.22M and Cost of 68.66M... so, a negative number makes sense, right?

t_vijay_qlik
Contributor III
Contributor III
Author

Hi,

Increasing the scaling as in the axis its showing from 0 to 20M

so 0,5,10,15,20M

sunny_talwar

So, instead of seeing 0,2M,4M,6M,8M,10M,12M... you want to see 0,5M,10M,15M,20M? But your max data is under 12M, why are you looking to go beyond 15M?

t_vijay_qlik
Contributor III
Contributor III
Author

Hi,

i outuput need to get isCapture8.PNG

Capture7.PNG

what i meant to ask about scaling is like this that if we increase so that product subcategory all values will be displayed is it so?

Capture9.PNG