Need Help

[chinnuchinni]

is there  any way to comparison same as alternate states with out using alternate states .

[YoussefBelloum]

Hi,

describe your scenario, the way you want to make comparison

[martinpohl]

create seperate fields with the values you want to compare (year, customer, region, product group) twice

then create expressions like

sum({<region={$=concat(region1,',')}year={}$=concat(year1,',')>} sales)

and for the other selection

sum({<region={$=concat(region2,',')}year={}$=concat(year2,',')>} sales)

regards

[chinnuchinni]

Sales comparison with year and month selection

[chinnuchinni]

its not giving the desired result

[MK9885]

Maybe right click on the object and use 'Set Reference' it is inbuilt qlik feature

[krishnacbe]

Share some Sample data and expected output

[uroboros]

Use Set analysis, some like this:

Sales of this month:     Sum({<month={=$(Max(month))}, year={$(=Max(Year)))}>} value)

last Year Sales.           Sum({<month={=$(Max(month))}, year={$(=Max(Year)-1))}>} value)

This is an example to do. You only need use some like this.

Regards.

Miguel