Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Dinamic Profit and loss

Hi Everyone,

I have and special request, have some tables with different  percentaje of participation:

Distribution ACenter%
PersonalIND25
PYME10
CONS30
MAS35
   
Distribution BCenter%
SalesIND10
PYME30
CONS20
MAS40
   
Distribution CCenter%
ComisionIND40
PYME30
CONS15
MAS15

 

And on the other I have my Profit and Lost table, what I want to do is to change the values of the accounts dinamically to any of the Distribution A,B or C (basically on demand in the design)

Distribution TotalINDPYMECONSMAS
 Sales81001875141020802735
ACredit5000125050015001750
BDollar2000200600400800
CPaycheck1000400300150150
ACards10025103035

 

Note.- Distribution is variable and on demand, the client need to change for account the distribution in the desing

Example I want to change the account Cards to other distribution change A from C and then the table has to recalculated.

This example is in Account level so the father Sales account has to sum the new values.

Distribution TotalINDPYMECONSMAS
 Sales81001890143020652715
ACredit5000125050015001750
BDollar2000200600400800
CPaycheck1000400300150150
CCards10040301515

 

Is it posible to make this kind of dinamyc selection in a table or should be variable objects? The problem I see is the sum of the father count in the table. Anyway Hope any suggestion.

 

Regards,

Jose

 

Labels (2)
0 Replies