Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kpradeep5610
Contributor III
Contributor III

Two Different selections on a field and find the differences on selected field values

Hi All,

please help me to find out the below problem.

i have a field Which is "DATE_Field" in this if i select any two dates on my interest  it will give the differences between on those selected dates 

Example 

WeekAsOn
24-apr-2020
17-apr-2020
10-apr -2020
31-may-2020
 

 

 

 

Please help me to find it 

 

 

Regards,

Pradeep K.

 

 

 

Labels (1)
2 Replies
Taoufiq_Zarra

I hope this example will help you.

=Date#(Subfield(concat(WeekAsOn,','),',',2),'DD-MMM-YYYY')-Date#(Subfield(concat(WeekAsOn,','),',',1),'DD-MMM-YYYY')

 

Capture.JPG

 

 

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
kpradeep5610
Contributor III
Contributor III
Author

Hi Zarra,

Thanks for reply

i'm not getting the differences on two selections, because of here i'm using 3 measures. and please follow the attached png image for reference. and please tell me what is your measures.

 

 

Regards,

Pradeep K.