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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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") 😉