Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
t_vijay_qlik
New 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

Re:Sales Analysis

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

Capture.PNG

Re:Sales Analysis

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

Re:Sales Analysis

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
New Contributor III

Re:Sales Analysis

Hi,

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

so 0,5,10,15,20M

Re:Sales Analysis

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
New Contributor III

Re:Sales Analysis

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