Straight table

[marishnagendran]

Dear All,

Branch	Customer	Target	Achieved
Branch 1	Customer 1	100	50
Branch 1	Customer 2	100	20
Branch 1	Customer 3	0	20
Branch 1	Customer 4	0	40
Branch 2	Customer 1	40	20
Branch 2	Customer 5	0	50

A above is my transaction table

Output is

Branch	Target	Achieved	Without Target Achieved
Branch 1	200	130	60
Branch 2	40	70	50

If target is 0 for the customer then in

Without target achieved column gets calculated. Is it possible????

[petter]

[ TIP: to show any contributor that you like and appreciate their answers please CLICK the like icon (thumbs up) ]

Yes you could do it with "If" like this:

Sum( If( Target=0) , Achieved )

or with "Set Expression" like this

Sum( {<Target={0}>} Achieved )

[marishnagendran]

In  Transaction table column Target and achieved or calculated field

In my output if i add customer name your expression is working. but i don't to show customer name

[petter]

It get it to work perfectly for me without involving the customer name or showing the customer name.... that is if you orginal "transaction table" is like you said it is...

[marishnagendran]

Sorry that is not my transaction table.

In my front end i calculated the target and achieved column.

Branch	Customer	Target	Achieved
Branch 1	Customer 1	100	50
Branch 1	Customer 2	100	20
Branch 1	Customer 3	0	20
Branch 1	Customer 4	0	40
Branch 2	Customer 1	40	20
Branch 2	Customer 5	0	50

Above i calculated the target and achieved column based on expression

I need output like this

Branch	Target	Achieved	Without Target Achieved
Branch 1	200	130	60
Branch 2	40	70	50

[petter]

Could you please provide more specific details so we don't have to guess how you underlying calculations or base tables are? Maybe you have a small sample application that you could share with the relevant data, charts and expressions?

[marishnagendran]

This is a requirement

Branch	Customer	Target	Achieved
Branch 1	Customer 1	100	50
Branch 1	Customer 2	100	20
Branch 1	Customer 3	0	20
Branch 1	Customer 4	0	40
Branch 2	Customer 1	40	20
Branch 2	Customer 5	0	50

The above is my straight table in Qliksense. In that Target and Achieved are measures Branch and customer are dimensions

For Management peoples they need

Branch	Target	Achieved	Without Target Achieved
Branch 1	200	130	60
Branch 2	40	70	50

Customer whose have a O value in Target.But sales is happens then i want to show that value in Without Target Achieved Column

Out Put table

Branch is dimension

Target,Achieved,Without Target Achieved are measures.

[petter]

So how does the expressions for the Target and Achieved measures look like? The full expresson with all operators and functions?

[marishnagendran]

Max fiscal year and max of month is used in that expression

[petter · Accepted solution]

Max fiscal year and max month can't really return an amount... so it doesn't seem to be the full expression... 

Since you're not giving a complete expression I can only hint in which direction you have to try.... something like this:

Sum( Aggr( If( <target-expression> =0,  <amount-expression> ) , dim1 , dim2 , ... )