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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Substract PV Table

Hello, How can I do this?

I have an expression gave me different results for months.

Like:

               Jan  Feb  Mar

results     45    48    85

I need a second row with this:

Feb - Jan,  Mar-Feb

     3               40

and so on.

Thank you

4 Replies
pgalvezt
Specialist
Specialist
Author

I Put a Jpg image what I want is the difference between periods:

In this case would be -201229027

pgalvezt
Specialist
Specialist
Author

Any Help?

manojkvrajan
Luminary
Luminary

I want to double check, if you want to display the monthly value difference in rows or columns.

It is easy to display in columns using the Column() function. However, please provide some more details.

 

pgalvezt
Specialist
Specialist
Author

If you take a look to the jpg file you will see what I want. I have selected apr and may both of them show a results but is just one expression. I need the diference of that expression (Sum(Total*[% DD])) and other Row would have the difference like may - apr.