Histogram - No numeric values on x-axis?

NickHoff — Tue, 18 Oct 2016 16:42:59 GMT

I'm attempting to create a Histogram for my data, which I already have the bins. For my dimension I'm using the following:

=$(eCostLevel)

Which is @CostDescriptionField in the inline table below:

CostLevel:

LOAD * INLINE [

@CostLevelID, @CostLevel, @CostDescriptionField

1, HCA, HCACostDescription

2, Group, GroupCostDescription

3, Division, DivisionCostDescription

4, Market, MarketCostDescription

5, Facility, FacilityCostDescription

];

In my data model I have an indicator assigned to each @CostLeveID ranking from 1-8 depending on where in the innerquartile range the ID falls based on their Cost Per Case compared to a Benchmark. The description is created with the following for each CostLevel:

FacilityCostScore,

IF(FacilityCostScore = 1, 'LESS THAN 1.0%',

IF(FacilityCostScore = 2,'BETWEEN 1.1% and 5.0%',

IF(FacilityCostScore = 3,'BETWEEN 5.1% and 25.0%',

IF(FacilityCostScore = 4, 'BETWEEN 25.1% and 50.0%',

IF(FacilityCostScore = 5,'BETWEEN 50.1% and 75.0%',

IF(FacilityCostScore = 6,'BETWEEN 75.1% and 95.0%',

IF(FacilityCostScore = 7,'BETWEEN 95.1% and 99.0%',

IF(FacilityCostScore = 8,'GREATER THAN 99.1%')))))))) AS FacilityCostDescription

My expression in the table is the following:

=COUNT({[Benchmark]<ProcGroup = {$(eProcedureGroup)},ZeroSurgicalUsedWastedIND = {'No'}>}DISTINCT SurgicalCaseSk)

All the data displays correctly until I check Continuous on the axes tab, then I'm greeted with the following error:

Re: Histogram - No numeric values on x-axis?

sunny_talwar — Tue, 18 Oct 2016 17:09:29 GMT

May be try with Dual function in for your dimension:

FacilityCostScore,

IF(FacilityCostScore = 1, Dual('LESS THAN 1.0%', 1),

IF(FacilityCostScore = 2,Dual('BETWEEN 1.1% and 5.0%', 2),...

))))))) AS FacilityCostDescription

Re: Histogram - No numeric values on x-axis?

NickHoff — Tue, 18 Oct 2016 17:50:28 GMT

That works, but how can I get the dimension to display the correct labels instead of 1-8? I could always make a legend.

Re: Histogram - No numeric values on x-axis?

sunny_talwar — Tue, 18 Oct 2016 17:51:48 GMT

I am not sure if you would be able to do this with continuous axis. I am not 100% sure though.

topic Re: Histogram - No numeric values on x-axis? in QlikView

Histogram - No numeric values on x-axis?

Re: Histogram - No numeric values on x-axis?

Re: Histogram - No numeric values on x-axis?

Re: Histogram - No numeric values on x-axis?