Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to calculate the Actual's Total

Need help on how to calculate on the Actual's Total

and also remove the background color of the header.

Here's the screenshot.

Screen shot 2014-04-08 at 10.50.16 PM.png

See the attach file.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Expression: =Sum(Aggr(sum(TimeDuration)/count(Group),Group,Year_Val))

PFA

View solution in original post

5 Replies
tresesco
MVP
MVP

Expression: =Sum(Aggr(sum(TimeDuration)/count(Group),Group,Year_Val))

PFA

sujeetsingh
Master III
Master III

See this

Not applicable
Author

Thank you for your reply it helps me allot

Not applicable
Author

Hello everyone,

I like to analyse the Target and Current Revenue.Below is the scenario,

Current Revenue per month- 80,000

My target -1,00,000

Travelling Expenses-10,000

Electricity Charges -3000

Other Expenses    -1000.

My Questions is that:

I have a Gauge Chart where One end will display the Current Revenue and opposite will display the Target which I want to achieve.i have three slider control in which Travelling expenses amount,Electricity charges amount and Other Expenses amount are assigned.

If i decreases the Expenses in slider, then automatically my Current Revenue have to increases and

should moves to the target.How can i do this.Give me the code to do it.Please help me.

Not applicable
Author

HI ALL NEW CLIENT

IM BIG HACKER GOOD

When you contact me I need your trust , I only work with reliable buyers...

IM SELL CVV GOOD AND FRESH ALL COUNTRY,ACCOUNT PAYPAL ,DO TRANSFER WU ,TRANSFER BANK OR BANK LOGINS,DUMPS AND TRACK1/2 FRESH HIGHT BALANCE

TRUST AND ADD ME

*Email   : lifegood2101986@gmail.com

*ICQ     :  653649023

PRICE LIST :

list cc i have and price i have :

- Us ( vis,mas )  = 4$/1cvv

- Us ( dis,amex ) = 6$/1cvv

- Uk ( vis,mas )  = 6$/1cvv

- Uk ( amex,dis)  = 7$/1cvv

- Au =  10$/1cvv

- Ca =  10$/1cvv

- Eu =  20$/1cvv

- Itali   =  18$/1cvv

- Spain   =  18$/1cvv

- Denmark =  25$/1cvv

- Sweden  =  18$/1cvv

- France  =  15$/1

- Germany =  15$/1

- Ireland =  15$/1

- New zeland  = 15$/1

- Switherland = 15$/1

- Slovakia    = 15$/1

- Middle East = 15$/1cvv

- Asia        = 15$/1cvv

- Uk with bin = 15$

- Uk with dob = 20$

- Uk with bin + dob = 30$

- Us full = 30$/1cvv

- Uk full = 40$/1cvv

- Eu full = 50$/1cvv

- And All CC - CVV Country

-->> If you buy many i will discount for you

----------------------------

.....Prices For Western Union Online....

+ Business Big Every day

+ Transfer : US,UK,CA,AU,EU,France,Germany,Italy and very easy to cashout African:

+ Price :

- 150$ = 1500$

- 300$ = 4000$

- 550$ = 6000$

- 700$ = 7500$

===>>> Beacause I hacker Really , so i do bug Wu Price Hight

* Give me your western union info and payment me fee transfer's.

Then i will do transfer's for you, After about 30 mins you'll have MTCN and sender name

Bank login ( All Bank ) ----------

- Bank BOA Us :

. Balance 5000$ = 300$

. Balance 9000$ = 400$

. Balance 18000$ = 800$

- Bank HSBC US :

. Balance 12000$ = 400$

. Balance 28000$ = 1000$

- Bank HSBC UK :

. Balance 6000 GBP = 300 GBP

. Balance 10000 GBP = 700 GBP

- And have more Bank account login with more country

- If u real want to buy and make bussiness with me let's contact me now

- I always check the balance and login details before selling

--------- Dumps / Track 1&2 For Price ----------

* Dumps,Tracks 1&2 US = $60 per 1

* Dumps,Tracks 1&2 UK = $90 per 1

* Dumps,Tracks 1&2 CA = $90 per 1

* Dumps,Tracks 1&2 AU = $80 per 1

* Dumps,Tracks 1&2 EU = $90 per 1

- Will check with hight balance

- Sample track 1&2

Track 1: B5232556061018719WYATT/ROBERTSON1007101171410000271000000

Track 2: 5232556061018719=10071011000042400000

TRACK 1: B4490360696278529^COPPEDGE/MATHILDE D^1306101000000000004070000274

TRACK 2: 4490360696278529=13061010407000027400

TRACK 1: B4490360696573648^DEB/AMRITA^1212101000000000001720008431

TRACK 2: 4490360696573648=12121010172000843100

pin: 5678,5432,5187,5505...and much pin other

-Sample DUMPS

5423201104769585=15071060000012430037

Chile | N/A | SANTIAGO | BANCO SANTANDER CHILE | MASTERCARD | STANDART

4966711001306493=13081060000019290035

Chile | N/A | Santiago | BANCO SANTANDER-CHILE | VISA | GOLD/PREM | CREDIT |

4500030105441897=14092010003026090201

Canadian Imperial Bank of Commerce CREDIT GOLD/PREM Canada Toronto Ontario ON

--------------- My Business RULE -----------

- And have more Bank account login with more country

- If u real want to buy and make bussiness with me lets contact me now

- dont trust dont talk more

- you send money => i send Cvv2 good

- no test free

- u can buy 1 test,if good u can buy more

- if not good ,i will change for u

- i very hate do spam or rip and i don want who spam me

- all my cvv are tested before sell, thats sure

- i accept PM (Perfectmoney.com) or WU but i only accept WU > 100

- I was so happy to see you actually make more money from the business with me

thank you all . When you believe I and work with me

- contact me .if you need me

*Email   : lifegood2101986@gmail.com

*ICQ     : 653649023

--------------- make money for you , thank you ------welcome you ----------