topic Re: Classification calculation in QlikView

Classification calculation

Wed, 22 Jan 2014 03:22:23 GMT

Hi all,

I'm confused about an issue.In the attached qvd file, you'll see there are "Gender__c" and "Hobby__c" fields.

For the value of "Gender__c" field is either "Female" or "Male", so I can calculate the corresponding records' total(as below):

But for the value of "Hobby__c" field is in the format of combination, just like:

So, if I want to calculate the records' total that "Hobby__c" is "Travel", how should I do ?

Thanks,

CoCo

Anonymous — Wed, 22 Jan 2014 03:45:41 GMT

Try:

Count(WildMatch(Hobby_c,'*Travel*'))

jagan — Wed, 22 Jan 2014 03:54:23 GMT

Hi,

Try like this

Count({<Hobby__c={"Travel"}>} [Account Id])

Count({<Hobby__c={"Travel, "}>} [Account Id])

Count({<Hobby__c={"*Travel*"}>} [Account Id])

Replace Travel value with the value in your field.

Regards,

Jagan.

Wed, 22 Jan 2014 05:20:01 GMT

Hi Jagan,

Thanks too much.

CoCo