topic Re: Expression in bar chart in QlikView

Expression in bar chart

Anonymous — Thu, 28 Dec 2017 10:21:14 GMT

Hi ,

I am trying to write an expression in a bar and line combo chart.

when I am writing below expression the value is coming different in the chart and different in Straight table.

Expression in Straight table- I have Region as a dimension in staright table which is having value apac and emeia.

Premium value : NUM(ROUND(SUM({<Month=,TDimMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}TSummary.Value)))

Expression in Bar Chart

Premium Value : Sum({<Month=,TMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}if(Region='APAC',TSummary.Value))

Sum({<Month=,TMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}if(Region='EMEIA',TSummary.Value))

Please help how can i write the expression in bar chart which will give the same value as in straight table.

Anonymous — Thu, 28 Dec 2017 10:22:41 GMT

Hi Nikita,

Pls share the sample data so that I can try for solution

Thank you.

PrashantSangle — Thu, 28 Dec 2017 10:35:16 GMT

in both chart are you using same dimension?

By the way you can optimize your expression like.

Sum({<Region={'APAC'},Month=,TMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}TSummary.Value)

Sum({<Region={'EMEIA'},Month=,TMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}TSummary.Value)

Anonymous — Thu, 28 Dec 2017 11:03:21 GMT

Thanks Prashant.

It worked.