topic Re: Need Help in QlikView

Need Help

chinnuchinni — Wed, 25 Nov 2020 16:16:04 GMT

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

YoussefBelloum — Mon, 18 Dec 2017 11:10:24 GMT

Hi,

describe your scenario, the way you want to make comparison

martinpohl — Mon, 18 Dec 2017 11:27:12 GMT

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 — Mon, 18 Dec 2017 12:05:47 GMT

Sales comparison with year and month selection

chinnuchinni — Mon, 18 Dec 2017 12:07:33 GMT

its not giving the desired result

MK9885 — Mon, 18 Dec 2017 16:11:51 GMT

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

krishnacbe — Mon, 18 Dec 2017 16:15:30 GMT

Share some Sample data and expected output

uroboros — Mon, 18 Dec 2017 16:30:31 GMT

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