Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2011-02-08 07:47 AM

Sum of data not reflecting in pivot table - when the data is changing acc to the selection

Hi,

I have a pivot table where I have the expression as





(

(Sum(CF_AMT)-(sum(CF_AMT)*Per_Sales/100)) + Before((sum(CF_AMT)*Per_Sales/100),delay_Sales))

I have 2 slider objects to change the values of the 2 variables "Per_Sales" and "delay_Sales".

The value of the expression changes acc to the values selected for the variables BUT my problem is the TOTAL (using show partial sums) doesn't change acc to the values. It is fixed. I have used the before() function here.

Does anybody have a solution for this. Kindly help.

Thanks.





566 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2011-02-08 08:08 AM
Author

Hi,

Your per_Sales and delay_sales are not wrapped in an aggregation function (e.g. Sum/Min/Max) so QlikView will not know how to total/sum them.

Cheers.

Ad.

293 Views
0 Likes
Anonymous
Not applicable
‎2011-02-08 08:59 AM
Author

In response to Anonymous

No.. it doesn't work

thanks for ur reply

293 Views
0 Likes