topic Re: Formula Help in QlikView

Formula Help

Wed, 22 Oct 2014 11:27:29 GMT

I have created a Qlikview app but ran into an issue with rolling up totals based on a dimension. Here is a snapshot of the app and the expressions I am using. What I am looking to do is roll up the totals for each distinct dimension.

I have two expressions pulling from the same table, one that pulls the positive number as sales and the second to pull the negative numbers as credits. What I need to do is roll up the numbers based on a second dimension. for example: Instead of seeing all of the transactions for 3Fish I would only see the total of sales and the total of credits.

Sales: sum(if(Total_Merchandise_Dollars >=1, Total_Merchandise_Dollars) - (Total_Other_Pricing))

Credits: sum(if(Total_Merchandise_Total <=0, Total_Merchandise_Dollars) - (Total_Other_Pricing))

Any assistance is greatly appreciated.

Re: Formula Help

Gysbert_Wassenaar — Wed, 22 Oct 2014 12:12:36 GMT

What I need to do is roll up the numbers based on a second dimension. for example: Instead of seeing all of the transactions for 3Fish I would only see the total of sales and the total of credits.

Then remove the other dimensions so that only the Customer Name is used as dimension.

Re: Formula Help

Wed, 22 Oct 2014 12:21:33 GMT

Now I feel dumb, I can do that but then I loose the granularity that I need.

Re: Formula Help

Gysbert_Wassenaar — Wed, 22 Oct 2014 12:27:00 GMT

Perhaps you can use a pivot table then and expand the dimensions at need to see the lower granularity.

Re: Formula Help

Wed, 22 Oct 2014 12:32:46 GMT

That is what I am about to attempt.

Thanks for the help, much appreciated.

Re: Formula Help

Wed, 22 Oct 2014 12:46:41 GMT

Not exactly what I need but it will suffice.

Thanks..