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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Oscar101
Contributor
Contributor

How to add a fix amount ( with out conditions or dynamics) to the value of a field ( with preconditions) , in 1 specific row and column

Hi

I have a pre-set sheet with all the formulas and conditions working fine in Qlick sense.

But.

There was a problem in the integration of sales, and one sale got into the system with a different codification than it should be ( that part cant be fixed, but wont happen again)

So now my report does not take into consideration  the amount of those specific 3 sales.

I want to make it simple, so instead of asking the report to integrate those 3 documents numbers, i just want to add a fix amount in the report, in a specific row ( store) and column ( type of sale). 

So where it add now 219.274,23 € from the normal documents as it is set i want to add lets say 3000 euros. ( as a fix thing, not by any new equation)

I want it in the spot in yellow. ( see picture below)

Long story short : How can i add a fixed value to the value of a field ( that comes from preset conditions) but only in a certain row and column ( store, type of sale).

The easiest way possible, as its a quick fix, just so the statistics do not drag this difference forever.

 

Thanks is advance!

 

Oscar101_0-1687534766380.png

 

 

 

Labels (1)
0 Replies