topic Re: Set Analysis Values Change in Straight Table in QlikView

Set Analysis Values Change in Straight Table

Anonymous — Sat, 22 Apr 2017 23:07:23 GMT

I have been developing two models of attribution. One where a person is directly connected to $ and another where the person is connected to $ through an intermediary account.

The issue I am having is that the calculation at the account level is not working as expected in a straight table. When there are no selections it is inaccurate ... when I select only one value, it is accurate. I tried to provide an example below as well as the calculations and data models. I know this is a long shot, but I would appreciate any help.

thanks,

- dave

No Selections

Selection

Column1 - Camp.Campaign Name (Scooby)

Column2 - NOT working as expected

Sum({<[AcctOpps.Upsell ARR (converted)] = {">0"}>} If([AcctOpps.Close Date] > [Camp.Campaign Start Date],Aggr(Only([AcctOpps.Upsell ARR (converted)]),[AcctOpps.Opportunity ID])))

Column3 - Working as expected

sum({<[Opps.Upsell ARR (converted)] = {">0"}>} If([Opps.Close Date] > [Camp.Campaign Start Date], [Opps.Upsell ARR (converted)]))

Re: Set Analysis Values Change in Straight Table

Kushal_Chawda — Sun, 23 Apr 2017 07:24:01 GMT

may be like

Sum({<[AcctOpps.Upsell ARR (converted)] = {">0"}>} aggr(If([AcctOpps.Close Date] > [Camp.Campaign Start Date],[AcctOpps.Upsell ARR (converted)]),[AcctOpps.Opportunity ID],[Camp.Campaign Name]))

Re: Set Analysis Values Change in Straight Table

vinieme12 — Sun, 23 Apr 2017 07:34:37 GMT

Please post a sample app, it may be a data model issue

Preparing examples for Upload - Reduction and Data Scrambling

Re: Set Analysis Values Change in Straight Table

Anonymous — Sun, 23 Apr 2017 13:22:03 GMT

amazing job kushal! thank you SO much. do you have any references I can use to learn this? it looks like you moved the if inside the aggr and added campaign name to the aggr as well, but I dont completely understand why this works

Re: Set Analysis Values Change in Straight Table

Anonymous — Sun, 23 Apr 2017 13:22:15 GMT

thank you for the resourced vineeth

Re: Set Analysis Values Change in Straight Table

Kushal_Chawda — Mon, 24 Apr 2017 05:57:16 GMT

See the below link to understand what aggr function is

https://www.analyticsvidhya.com/blog/2014/02/aggr/

Also you can read the blogs on aggr function which will truly help you to understand the aggr function