Set analysis for Previous Year sales for a particular company

[arunqlik2view]

Hello All,

I'm trying to create a comparison bar chart in qlikview , where it shows the sales between two years, selected year and previous year.

I was able to create the chart for all companies but when I tried to filter the chart to a particular company , I have issue .

This is the First primary expression for the selected year for the company "Abc" - Works fine

sum({<Company.Name={'Abc'}>}[Value])

This is the Second primary expression for the previous year for the company "Abc" -  Have Issue Here

Sum({$<Year={$(=max(Year)-1)}>}{<Company.Name={'Abc'}>}[Value])

also tried from this website https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/ but no luck with it either.

Please advice on this regard.

Expected output look. ---

[tresesco · Accepted solution]

Try like:

=Sum({$<Year={$(=max(Year)-1)} , Company.Name={'Abc'}>}[Value])

If this doesn't work, try to share your sample qvw.

[kfoudhaily]

Hello, please try this;

sum(

        {$<

        Year={"$(=max(Year)-1)"},

        Company.Name={'Abc'}

        >}

        [Value]

        )

[arunqlik2view]

works perfectly , thank you so much

[arunqlik2view]

thanks for the reply