topic Re: Set Analysis help in QlikView

Set Analysis help

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

Please find attached file with data.

I want to have different count of data

when i click on RM1

for date 30/05/2017

i should get count of Id's which are closed,downgrade,regrouped separately .

Out Put Expected:

Selection: RM1, 30/05/2017

Start of Month : 5

Closed :1

Downgrade:1

Downgrade Regroup:1

End of Month : 2

Re: Set Analysis help

saumyashah90 — Tue, 30 May 2017 11:22:17 GMT

any one?

Re: Set Analysis help

prma7799 — Tue, 30 May 2017 11:31:43 GMT

Can you please share expected output

Re: Set Analysis help

Anil_Babu_Samineni — Tue, 30 May 2017 11:38:03 GMT

You have to explain the result whether how you will get.

Re: Set Analysis help

saumyashah90 — Tue, 30 May 2017 11:38:22 GMT

if i get this in any format is good with me(Text Box, chart,table,etc).

Expected Output:

Selection: RM1, 30/05/2017

Start of Month(End of previous month count) : 5

Closed :1

Downgrade:1

Downgrade Regroup:1

End of Month : 2

Re: Set Analysis help

prma7799 — Tue, 30 May 2017 11:39:20 GMT

As Anil said I want to know How we will get desire output.

Re: Set Analysis help

saumyashah90 — Tue, 30 May 2017 11:43:26 GMT

'No change' type1 are the ID's which are active

'Downgrade' type1 are the ID's which are closed in this month.

So here when you see there some ID's which are active in April but 3 ID's get closed in May(Closed,Downgrade,Regroup). hence current month end only 2 ID's are active. This Count will become start of my next month(June).

Issue is there is no RM1 tagged in Current month for those ID's which are Downgrade(Type1).

So on selection of RM1 and Current month date i need count of ID's which are closed,downgrade and regroup.

Re: Set Analysis help

Tue, 30 May 2017 11:48:44 GMT

From what I understand your selection of RM1 will result in showing 0 values for closed,downgrade and so on.

In order to avoid this, you can use {1} In your set condition to ignore selections

=Count({<[Date]={$(=Max({1} [Date]))}, [Dataset Name])

in this manner

I hope it helps

Re: Set Analysis help

saumyashah90 — Tue, 30 May 2017 11:50:16 GMT

{1} would be helpful if RM1 is tagged to it in current month.

Re: Set Analysis help

Tue, 30 May 2017 11:58:33 GMT

could we map ID column and RM together?

Eg: replace the null values in the column loaded with the value obtained after comparing it with ID?

Re: Set Analysis help

saumyashah90 — Tue, 30 May 2017 12:13:17 GMT

You will have to check previous month RM to that ID and tagg the same to null in current month.

Re: Set Analysis help

saumyashah90 — Tue, 30 May 2017 12:14:05 GMT

'No change' type1 are the ID's which are active

'Downgrade' type1 are the ID's which are closed in this month.

Issue is there is no RM1 tagged in Current month for those ID's which are Downgrade(Type1).

So on selection of RM1 and Current month date i need count of ID's which are closed,downgrade and regroup.

Re: Set Analysis help

trdandamudi — Tue, 30 May 2017 13:08:41 GMT

Please see the attached file and hope this helps....

Re: Set Analysis help

saumyashah90 — Wed, 31 May 2017 01:19:23 GMT

Hi Thirumala,

Thanks for your response but

1) Data selected was a text

2) If there are more RM's it wont work. I have changed the date format and added one more RM2 so that it looks clear.

Request you to please help on the attached.

Re: Set Analysis help

trdandamudi — Wed, 31 May 2017 13:46:04 GMT

I tried but no able to achieve what you need.. But hope some one will help you out...

Re: Set Analysis help

saumyashah90 — Mon, 05 Jun 2017 10:18:05 GMT

Any one?

Re: Set Analysis help

MK9885 — Mon, 05 Jun 2017 12:02:05 GMT

I don't understand your requirement.

What are you looking for?

Count of records for end of previous month?

Provide a screenshot for expected output.

Maybe use Master Calendar and pivot/straight table for adding set expressions

Or stalwar1‌ can help you out in Set expressions.

Re: Set Analysis help

sunny_talwar — Mon, 05 Jun 2017 12:16:26 GMT

What is the expected output based on this new data?