topic Re: Set Analysis with a set in QlikView

Set Analysis with a set

Anonymous — Wed, 15 Nov 2017 11:24:19 GMT

Customer Name	Posting Date	Clearing	Value	Flag
A	31/10/2015	2/11/2017	22	1
A	31/10/2015	1/10/2017	14	0
A	31/10/2015	28/10/2017	12	0
A	25/10/2015	14/11/2017	32	1
A	25/10/2015	2/11/2017	14	0
A	15/10/2015	12/11/2017	23	1
A	15/10/2015	5/11/2017	11	0
A	15/10/2015	2/11/2017	11	0
A	11/10/2015	14/11/2017	9	1
A	11/10/2015	12/11/2017	2	0
A	11/10/2015	11/11/2017	10	0
A	11/10/2015	2/11/2017	9	0

Hi i have data in the above format the flag field is not their and even the customer not in the same table but i want to implement the set analysis on front end for all the flag =1 fields . i.e means i want to showcase only the flag=1 fields in front-end table for posting date till date selection . Suppose user gives a selection 31/10/2015 in posting date he should be able to see all the flag=1 records.(Note :- Clearing date is considering only the max date )

Re: Set Analysis with a set

shraddha_g — Wed, 15 Nov 2017 11:46:13 GMT

According to sample data, Please provide expected output

Re: Set Analysis with a set

Anil_Babu_Samineni — Wed, 15 Nov 2017 11:54:00 GMT

Perhaps this?

Only({<Flag = {1}>} [Customer Name])

OR, I believe you have something called expression. In that try to add Flag = {1}

Re: Set Analysis with a set

neha_shirsath — Wed, 15 Nov 2017 11:58:17 GMT

What you want to show exactly,Means count of customers with Flag =1 or Sum of value with Flag =1?

Re: Set Analysis with a set

Anonymous — Wed, 15 Nov 2017 11:58:28 GMT

Customer Name	Posting Date	Clearing	Value	Flag
A	31/10/2015	2/11/2017	22	1
A	25/10/2015	14/11/2017	32	1
A	15/10/2015	12/11/2017	23	1
A	11/10/2015	14/11/2017	9	1

This will be the Output

Re: Set Analysis with a set

Anonymous — Wed, 15 Nov 2017 11:59:34 GMT

I dnt have the Flag field as i cannot be created i want to do the following in the Front end cant go to backend creat new field .

Re: Set Analysis with a set

Anonymous — Wed, 15 Nov 2017 12:00:16 GMT

Sum of Values

Re: Set Analysis with a set

shraddha_g — Wed, 15 Nov 2017 14:50:21 GMT

Try

Sum({<Flag = {'1'},[Posting Date] = {"<= $(=max([Posting Date]))"},[Clearing Date] ={"=$(=max([Clearing Date]))"}>} Value)