Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ciphergod
Contributor III
Contributor III

Calculated Dimension giving 2 answer

Hi All,

 

Was doing a simple app when i face this issue, 

I am using 2 variables to calculate date using AddMonths function.

The formula is:

=AddMonths([Completed Date],[VALIDITY],)

The issue i am facing is that the formula 'works', when i put this new calculated dimension into a table, it gives 2 rows.

First row just shows me the default Completed Date, and a second row that gives the Completed Date + Validity.

Just want to know what went wrong to give this 2 results.

TIA

Labels (1)
1 Reply
Taoufiq_Zarra

can you share a sample data ? and

=AddMonths([Completed Date],[VALIDITY],)

Regards,
Taoufiq ZARRA

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

(you can mark up to 3 "solutions") 😉