topic Re: Calculation conditions in QlikView

Calculation conditions

deepakqlikview_123 — Fri, 12 Aug 2016 10:53:40 GMT

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 — Fri, 12 Aug 2016 10:56:13 GMT

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 — Fri, 12 Aug 2016 11:05:11 GMT

One column showing Net_Revenue

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

sunny_talwar — Fri, 12 Aug 2016 11:06:58 GMT

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

deepakqlikview_123 — Fri, 12 Aug 2016 11:14:26 GMT

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 — Fri, 12 Aug 2016 11:37:11 GMT

Hi Sunny,

is it possible to show like this in qliksense

deepakqlikview_123 — Tue, 16 Aug 2016 05:58:04 GMT

Hi All,

Can you please suggest on this.

Thanks