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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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") 😉