Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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 )

Tags (1)
7 Replies
Highlighted
Partner
Partner

Re: Set Analysis with a set

According to sample data, Please provide expected output

Highlighted

Re: Set Analysis with a set

Perhaps this?

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

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

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)
Highlighted
Specialist
Specialist

Re: Set Analysis with a set

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

Highlighted
Contributor II
Contributor II

Re: Set Analysis with a set

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

Highlighted
Contributor II
Contributor II

Re: Set Analysis with a set

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 .

Highlighted
Contributor II
Contributor II

Re: Set Analysis with a set

Sum of Values

Highlighted
Partner
Partner

Re: Set Analysis with a set

Try

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