topic Re: Set Ananysis in QlikView

Set Ananysis

smilingjohn — Thu, 23 Apr 2015 04:12:47 GMT

Hi All

I Have column name Customer_Dim_Key and

another column name Member_Dim_Key .

Now i want to get a bar chart like rvenue of member verses non-members

For member iam using the below expression :

sum( {$<MEMBERSHIP_DIM_KEY=>} NET_AMOUNT ) But this is giving my overall revenu .

.Now i need revenue for non Members alos which is ( Customer_Dim_Key - MEMBERSHIP_DIM_KEY)

i tired this using set analysis but could not achieve .

I need this for current year and Last year.

Can someone help me on this please.

Thanks in advance

arulsettu — Thu, 23 Apr 2015 04:54:01 GMT

post any sample data

Anonymous — Thu, 23 Apr 2015 05:31:48 GMT

Plz post sample data .

sum({$<{Customer_Dim_Key}-{MEMBERSHIP_DIM_KEY}>}[Net amount])

I am not sure that this will work.

please post your sample data .So that we can work on it .

Thanks