Calculation conditions

[deepakqlikview_123]

Hi All,

PFA.

I need to show one column having difference between

net revenue and group by particulars excepting bet revenue.

Mean

net revenue-Absolute margin

net revenue-Gross margin

Etc

Please suggest

[sunny_talwar]

What is the expected output here? and I believe we are looking at this table:

Note: You used data instead of Data and that's why the information was not showing for other rows

[deepakqlikview_123]

One column showing Net_Revenue

minus data group by particulars (Net Revenue also part of Particulars)

[sunny_talwar]

Can you point out what does the output needs to look like Numerically?

[deepakqlikview_123]

For Example in from of Contribution Margin first row should be calculated as

=sum({<PARTICULARS={'Net Revenue'}>}Data)

minus

sum({<PARTICULARS={'Contribution Margin'}>}Data)

and when we can expand patricular column it will show all data points as it is

[deepakqlikview_123]

Hi Sunny,

is it possible to show like this in qliksense

[deepakqlikview_123]

Hi All,

Can you please suggest on this.

Thanks