topic Re: set Analysis in QlikView

set Analysis

Thu, 26 Nov 2015 07:21:31 GMT

Hi,

how to find country wise sales when flag=1

tresB — Thu, 26 Nov 2015 07:29:21 GMT

=sum({<flag={1}>} Purgechar(sales,'M'))&'M'

Note: Your sales figure is not numeric, better convert them while loading.

Anonymous — Thu, 26 Nov 2015 07:31:07 GMT

Make it like this:

=sum({<flag={'1'}, Country={'*'}>}sales) //If you are mentioning Country={'*'} then both expression like =sum({<flag={'1'}>}sales) are same

if you want it for a specific country like:

=sum({<flag={'1'}, Country={'India'}>}sales)

I have checked your data where Sales field is having string values like 30M,40M where sum() will return 0.

First make sure Sales field shud have value like 30, 60, 70 , mean numeric value then it will work

PrashantSangle — Thu, 26 Nov 2015 07:31:24 GMT

Hi,

Since your sales field is not in number format therefore you can not sum it

1st you have convert it into number then

try sum({<Flag={1},Country=>}Sales)

Regards