topic Re: Alternate States combining rows in QlikView

Alternate States combining rows

Wed, 23 Dec 2015 16:14:49 GMT

Hi,

I have three states in my app.

Default, alt, alt2.

default is this years revenue

alt is last last years revenue

and alt is last years revenue

I need to combine all three rows to say the this years date so all rows with their revenue to one row for 21/12/2015.

Please can anyone help?

Anonymous — Wed, 23 Dec 2015 16:29:03 GMT

Using Set Analysis you evaluate for each specific Alternate State, maybe something like this :

sum( {$} Sales ) + sum( {alt} Sales ) + sum( {alt2} Sales )

Wed, 23 Dec 2015 16:30:36 GMT

thanks for your response.

where would you put that? I want each state to have its own column but combine a row, so get rid of the zeros