Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis with a set

Customer NamePosting DateClearingValueFlag
A31/10/20152/11/2017221
A31/10/20151/10/2017140
A31/10/201528/10/2017120
A25/10/201514/11/2017321
A25/10/20152/11/2017140
A15/10/201512/11/2017231
A15/10/20155/11/2017110
A15/10/20152/11/2017110
A11/10/201514/11/201791
A11/10/201512/11/201720
A11/10/201511/11/2017100
A11/10/20152/11/20179

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 )

7 Replies
shraddha_g
Partner - Master III
Partner - Master III

According to sample data, Please provide expected output

Anil_Babu_Samineni

Perhaps this?

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

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
neha_shirsath
Specialist
Specialist

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

Anonymous
Not applicable
Author

Customer NamePosting DateClearingValueFlag
A31/10/20152/11/2017221
A25/10/201514/11/2017321
A15/10/201512/11/2017231
A11/10/201514/11/201791

This will be the Output

Anonymous
Not applicable
Author

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 .

Anonymous
Not applicable
Author

Sum of Values

shraddha_g
Partner - Master III
Partner - Master III

Try

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