Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
JAN. 24, Q&A with Qlik: Making the Move to Qlik Cloud Reporting: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rammuthiah
Creator III
Creator III

Find Previous Date upto 5 days

Need logic to find sheet 2 Date given in below sample data

Date find.JPG

1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

could you be more specific

something like

if([Sheet 1 Date]-[Sheet 2 Date]=5,[Sheet 2 Date],null())   ????


regards

Pradosh

Learning never stops.

View solution in original post

2 Replies
pradosh_thakur
Master II
Master II

could you be more specific

something like

if([Sheet 1 Date]-[Sheet 2 Date]=5,[Sheet 2 Date],null())   ????


regards

Pradosh

Learning never stops.
MK9885
Master II
Master II

Day-5 would give you 5 days back.

In script use

day([Sheet 1 Date]) as Sheet1Day,

day([Sheet 2 Date]) as Sheet2Day,

In expression use

sum({<Sheet1Day=  {$(=(Sheet1Day)-5)}>}(Sheet1Day))

Not sure if the expression is correct but it would give me the values against day selected.