A straight Table Problem - Qlik Community

swapniltaz · ‎2019-06-26

Hi QLik experts ,

I have a situation where I want to Display Flow with volume , I have flow as A,B, C ,D,E

Problem : I want to introduce a Flow category X in Flow such that X is sum of C+D .

The O/p should be a s Below , i.e I want X to be displayed with C and D both along with Other Category

and while doing Total it should not double count , How can i achieve the same ?

Flow	Volume
A	10
B	20
X(C+D)	70	X is Sum of C+D
C	30
D	40
E	50
TOTAL	220

Brett_Bleess · ‎2019-07-23

You are likely not going to get much help on this one unless you can attach a qvw with what you have already etc... Be sure your data model is complete as you want it and you include some records as well. Not sure you are going to get anything otherwise on this one.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.