This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a question that i cant seem to solve.
I have the following table:
Since, the region is the same and the targets are the same, can we have the total to be 1,350,000 since all targets in the regions are the same?
Thank you in advance.
This is the output I have:
Do you mind sharing the QVF file?
Here is the script I've used:
Temp:LOAD * inline [Region Coverage, Users, TargetCentral,User1, 400000Central,User2, 25000Central,User3, 75000Central,User4, 300000Central,User5, 200000Central,User6, 0Central,User7, 250000East,User8, 1350000East,User9, 1350000East,User10, 1350000East,User11, 1350000West,User12, 350000West,User13, 100000West,User14, 200000];
You might be able to use this
Aggr(NODISTINCT Sum(DISTINCT Target), [Region Coverage]))
Hello Sunny, Thiago,
Using your script and expressions, this is what i get.
Except East, other regions have their own targets that should appear. Only east is the exception.
I am not entirely sure what you need, but may be this
If([Region Coverage] = 'East',
Aggr(NODISTINCT Sum(DISTINCT Target), [Region Coverage])),
Ill try your expression but please see below for desired result:
If(Dimensionality()=0,Sum(Targets),Sum(total <[Region Coverage]> distinct Targets))
I am guessing Current Result uses Sum(Target)... if it does, then I think this should work