Qlik Community

App Development

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

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
satyam285889
Contributor II
Contributor II

How to combine 2 values for new value in table?

I have this table below that shows unit per finance type. I was keep show these value, but add new finance type that adds up 'Finance' + 'Cash' together and show as 'Non-Lease'. 

Also 'Finance' + 'Lease' as 'Non-Cash'

 

 

satyam285889_0-1652504956399.png

EX:

satyam285889_1-1652505302635.png

 

 

 

 

Labels (1)
2 Replies
PrashantSangle

where do you want to do this logic to get implemented. in front end or in script ( back end)

 

In backend try like

Finance_table:

Load Deal,units from TableName;

concatenate

Load 'Non-Cash' as Deal,Sum(units) as units from TableName where wildmatch(Deal,'Finance','Cash');

concatenate

Load 'Non-Lease' as Deal,Sum(units) as units from TableName where wildmatch(Deal,''Finance,'Lease');

 

in front end you have to use valuelist() for this

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Sy...

 

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
satyam285889
Contributor II
Contributor II
Author

Front-end. I have a table.