Qlik Community

Qlik Sense App Development

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

sarasmonu
New Contributor III

Expression Calculation

Hi Team,

I am trying to do the below calculation:

(Latest Date Information - Information entered 14 days ago)/Information Entered 14 days ago

If we do have any data for that date ( "Information entered 14 days ago"), then we need to keep moving a day forward(13th day, 12th day etc) and consider the first available information .

Please help me in doing the above calculation.

Thanks,

Monu

Tags (1)
1 Reply
YoussefBelloum
Esteemed Contributor

Re: Expression Calculation

Hi,

I think you wanted to say:

If we do NOT have any data for that date ( "Information entered 14 days ago"), then we need to keep moving a day forward(13th day, 12th day etc) and consider the first available information .


Right ?


can you attach some data here ?