Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Set Analysis Date Match (Tricky Question)

All,

How do I make measure1 work like measure2 using set analysis?

 

Capture.JPG

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

maybe this:

load *,
recno() as recordNumber;
LOAD * INLINE [
Date1, Date2, Sale
1/1/2020, 1/1/2020, 100
1/1/2020, 1/2/2020, 200
];

=sum( {< recordNumber = {"=Date1 = Date2"} >} Sale )

I added the field "recordNumber" because you need a primay key.

I hope it can helps.

View solution in original post

1 Reply
Highlighted
Partner
Partner

maybe this:

load *,
recno() as recordNumber;
LOAD * INLINE [
Date1, Date2, Sale
1/1/2020, 1/1/2020, 100
1/1/2020, 1/2/2020, 200
];

=sum( {< recordNumber = {"=Date1 = Date2"} >} Sale )

I added the field "recordNumber" because you need a primay key.

I hope it can helps.

View solution in original post