topic Re: Count multi asset products in QlikView

Count multi asset products

vikasmahajan — Wed, 27 Jan 2016 04:51:49 GMT

Dear Team,

I have excel like attached format I have UserId,Products,Charge Month 3 columns in it , I want to show multiple asset products

like this

MultiAssetCheck:

LOAD user_sid , Product,charge_month

Count(Product) as 'Multi Asset'

Resident Asset

Group By user_sid , Product,charge_month ;

Expected o/p

I want to count the multiple assets records and filter the same in pivot table with multiple asset details.

thanks in adv.

Vikas

Re: Count multi asset products

rajeshforqlikvi — Wed, 27 Jan 2016 05:04:07 GMT

PFA,

Attached,

Re: Count multi asset products

jonathandienst — Wed, 27 Jan 2016 05:16:23 GMT

I am not sure what your question is. If you mean you want to perform this count in the front end, then create a table with user_sid, and charge_month as dimensions, and Count(Product) or Count(Distinct Product) as the expression.

If you only want to see the dimensions when multiple products exist, then use something like

=If(Count(Product) > 1, 1, 0)

and ensure that Suppress Zero Values is checked.

Re: Count multi asset products

vikasmahajan — Wed, 27 Jan 2016 05:23:42 GMT

thanks for your reply ,

Requirement is like this :

I have text box as MultiAseet when we click on text box , in pivot table we should able to see those records pertaining to multiaseet products , Now in pivot i want to flag those assets , who are multiple by product,user_id in each month

Urgent Please guide

Vikas

Re: Count multi asset products

settu_periasamy — Wed, 27 Jan 2016 05:26:00 GMT

May be this >

=If(Aggr(Nodistinct Count(UseID)>1,UseID,charge_month),1)

Re: Count multi asset products

vikasmahajan — Wed, 27 Jan 2016 05:32:28 GMT

Thanks Settu ,

I want to mark at script level can we use same formula in script and mark records as a multi asset , then using text box can i filter the same ?

Vikas

Re: Count multi asset products

vikasmahajan — Wed, 27 Jan 2016 05:39:50 GMT

Awaiting for your reply urgent please ...

Vikas

Re: Count multi asset products

settu_periasamy — Wed, 27 Jan 2016 05:44:10 GMT

Yes. You can add the script like below

Left Join (MulAsset)

LOAD UseID,

charge_month,

Count(Product) as 'Multi Asset'

Resident MulAsset Group By UseID ,charge_month ;

Check the Attachment..

Re: Count multi asset products

vikasmahajan — Wed, 27 Jan 2016 05:50:46 GMT

Thanks Settu.

Vikas