% of total after using Set Analysis to refine same field

[alextomlins]

Hi Qlik dudes

I am having an issue with Qlik sense and i imagine i must be doing something wrong. I am trying to get a percentage of people who unsubscribed from our service in the first day against the total number of those that subscribed.The problem is i have already used set analysis to refine the data set so i cannot then divide it against the total of said data set.

The expression i have so far is;

(Count({<tType = {'Subs'}, MYAuto = {">123"}, Segments={"First Day"}>} DISTINCT USID))

(Count({<tType = {'Subs'}, MYAuto = {">123"}>} DISTINCT USID))

Ignore tType and MYAuto they are just filtration I need for other reasons.

Thanks so much for your time - I am consistently impressed by how helpful people are on here.

Alex

[sunny_talwar]

The problem is i have already used set analysis to refine the data set so i cannot then divide it against the total of said data set.

Why is this? I am not sure I understand the problem. From the looks of your expression, I see nothing wrong with it... can you provide a sample to show your problem?