Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

issue when both expression and dimension having same column

Hi,

I am new to qlikview please bear with me if some silly issue.

I am trying to create a chart with  difference of sum of current and last month.e.g for below data i should get 6000 for month 7 selected

countrysalesmonth
japan10005
japan80006
japan20006
japan100007
france60007

using below expression and dimension as month

=sum({$<month={'$(=only(month))'}>} sales)-sum({$<month={'$(=only(month)-1)'}>} sales)

I am getting the values equal to current month 16000 and previous months sum -10000  while i am getting correct results if i am taking dimension as some constant 'c'.Can anybody please explain this behaviour .

Thanks,

Varun

1 Reply
khadeer_sparks
Valued Contributor

Re: issue when both expression and dimension having same column

Hi,

U can change the dimension name ... n use that expression... change the dimension label when showing in reports.

Regards,

Khadeer