# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Straight table

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????

1 Solution

Accepted Solutions
MVP

## Re: Straight table

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 , ... )

10 Replies
MVP

## Re: Straight table

[ 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 )

Contributor

## Re: Straight table

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

MVP

## Re: Straight table

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...

Contributor

## Re: Straight table

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

MVP

## Re: Straight table

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?

Contributor

## Re: Straight table

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.

MVP

## Re: Straight table

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

Contributor

## Re: Straight table

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

MVP

## Re: Straight table

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 , ... )