Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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????
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 , ... )
[ 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 )
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
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...
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 |
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?
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.
So how does the expressions for the Target and Achieved measures look like? The full expresson with all operators and functions?
Max fiscal year and max of month is used in that expression
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 , ... )