Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Gestion-PSD
Creator II
Creator II
‎2020-08-03 05:12 AM

Apply "reverse" map

Hi all!

We're developing an dashboard with data categorized by [client] and [date] (and [Hour] and [Type]). We must apply a "reverse" mapping for [clients], because values for one original client must be splitted 53%-47% between two clients.

Splitting should viewed on dashboard and nprinting reports (I mean, it's enough if we split data on expressions or calculated dimensions), but I think it's better to split data  on data model.

This is a sample of the data to be splitted (Incoming, Min_In, Outgoing, Min_Out)

Gestion-PSD_0-1596445589547.png

And example would be splitting 179 Comercia_COMER400 Incomings for 09/07/2020 10:00 to 94.87 for Comer401 and 84.13 for Comer402.

Have someone an idea about how to do that? 

 

 

Regards

Alonso Torres

580 Views
0 Likes
0 Replies