Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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") 😉