topic Two values for same date/year not showing in bar chart in QlikView

Two values for same date/year not showing in bar chart

Wed, 20 May 2015 11:06:53 GMT

Hi community!

I have an excel file that has estimate and actual values and sometimes both for the same day (2014) and when I create a bar chart that year with both values is not showing at all! How can I tell, already in the load phase, to load only the latter value (6,95 in this case)? Or to tell the chart which value to use?

Date Value

31.12.2016	9
31.12.2015	8,1
31.12.2014	8
31.12.2014	6,95
31.12.2013	7,54
31.12.2012	7,83
31.12.2011	8,2
31.12.2010	8,51

Thanks for your help!

Heidi

Re: Two values for same date/year not showing in bar chart

robert_mika — Wed, 20 May 2015 11:13:30 GMT

t1:

load * Inline [

Date, Value

31.12.2016, 9

31.12.2015 ,8,1

31.12.2014, 8

31.12.2014, 6,95

31.12.2013, 7,54

31.12.2012, 7,83

31.12.2011, 8,2

31.12.2010 ,8,51

]

;

t2:

load

Date as date,

lastValue(Value) as val

Resident t1

group by Date;

drop table t1

Re: Two values for same date/year not showing in bar chart

awhitfield — Wed, 20 May 2015 11:43:10 GMT

Hi Heidi,

looks like your expression is just Value, in which case you could try changing the expression to :

FirstSortedValue(Value, Value)

Which gives

HTH Andy

Re: Two values for same date/year not showing in bar chart

Wed, 20 May 2015 12:19:03 GMT

Thank you both solution worked!

-Heidi