Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
is there any way to comparison same as alternate states with out using alternate states .
Hi,
describe your scenario, the way you want to make comparison
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
Sales comparison with year and month selection
its not giving the desired result
Maybe right click on the object and use 'Set Reference' it is inbuilt qlik feature
Share some Sample data and expected output
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