topic Re: Finding TotalSales in QlikView

Finding TotalSales

NavinReddy — Mon, 08 Jul 2013 08:52:53 GMT

Hi All,

i Need to be finding TotalSales if condision is Actual,

i Need to be finding TotalGain if Condition is Plan

Help some

Regards

Niranjan

Mon, 08 Jul 2013 08:56:08 GMT

sum(Total if(field='Actual',Sales))

*****************************************

sum(Total if(field='Plan',Sales))

********************************************

or try this

sum(Total {$<field='Actual'}>}Sales)

*********************************

sum(Total {$<field='Plan'}>}sales)

Mon, 08 Jul 2013 08:56:52 GMT

Hi Niranjan,

Plz share sample file.

Always try to post with sample qvw file with less data.

It will help us guide you quickly.

Karthiks

er_mohit — Mon, 08 Jul 2013 09:04:55 GMT

sum(total if(field='Actual',Sales,if(field='Plan',Sales))

sum(total if(field='Actual',1,sales))

try this sum(total<field>losses)

sum(Total {$<field=>}sales)