Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
hemanthaanichet
Contributor III

Re: To show growth of current year MAT vs previous year MAT in bar chart

you can achieve by

in expression tab

first expression : sales expression

second expression : growth expression     

in the same tab you may find display options

for first expression check mark bar

for second expression check mark the line

Re: To show growth of current year MAT vs previous year MAT in bar chart

Would you be able to share a sample to see the issue?

tanykozel
New Contributor II

Re: To show growth of current year MAT vs previous year MAT in bar chart

Сервис хранения и передачи файлов - FEX.NET

You can get in from link above.

So, I can show growth only for months in  max chosen year, but need to show for all months if it's chosen more than 2 year...

Capture.JPGCapture1.JPG

Thank you !

I'm a new user in QV...

Re: To show growth of current year MAT vs previous year MAT in bar chart

Remove this part from your denominator

Capture.PNG

tanykozel
New Contributor II

Re: To show growth of current year MAT vs previous year MAT in bar chart

thank you Sunny,

I removed,

But when want to chose only one year got not very nice picture ... Can we remove figures of growth where not  sales ? thanxCapture.JPG

tanykozel
New Contributor II

Re: To show growth of current year MAT vs previous year MAT in bar chart

i got it ))))

thank you again