topic Re: Problem in setanalysis in QlikView

Problem in setanalysis

Anonymous — Mon, 29 Feb 2016 06:38:07 GMT

Hi,

I have problem in set analysis.

I have 3 dimensions like category ,product_id,listing_id.

Each product has one or more than listing id's.

I need to show in straight table below two expressions.

In first expression i need to show product count of listing id's count having one and like in another expression also count of pid's having listing count is 2.

Re: Problem in setanalysis

kaushiknsolanki — Mon, 29 Feb 2016 06:48:50 GMT

Hi,

Do you mean that you want the products which has only one Listing ID and in other expression you want Product Count where Listing count is 2.?

Regards,

Kaushik Solanki

Re: Problem in setanalysis

Anonymous — Mon, 29 Feb 2016 06:51:37 GMT

HI These are 2 expressions 1)count of products having lisitng_id count is 1

2)count of products haing lisitng_is count is 2

Re: Problem in setanalysis

Anonymous — Mon, 29 Feb 2016 06:52:15 GMT

Yes exactly

Re: Problem in setanalysis

jagan — Mon, 29 Feb 2016 06:59:12 GMT

HI,

Try like this

ListingID Count is 1:

Sum(Aggr(If(Count(Distinct Listing_ID) = 1, 1, 0), Product_ID))

ListingID Count is 2:

Sum(Aggr(If(Count(Distinct Listing_ID) = 2, 1, 0), Product_ID))

Hope this helps you.

Regards,

jagan.

Re: Problem in setanalysis

kaushiknsolanki — Mon, 29 Feb 2016 06:59:49 GMT

Hi,

Then create a straight table with dimension as Category.

Expression 1.

Count({<Product = {'=count(listing_id) = 1'}>}Product)

Expression 2:

Count({<Product = {'=count(listing_id) = 2'}>}Product)

Regards,

Kaushik Solanki

Re: Problem in setanalysis

Anonymous — Mon, 29 Feb 2016 07:22:54 GMT

Hi Kaushik,

Thanks for your replay.

In above expression Count(lisitng_id)=1 means it will take whole count of products but we need to filter here also with pid for coutn(lisitng_id)=1.

Re: Problem in setanalysis

Anonymous — Mon, 29 Feb 2016 07:23:44 GMT

Thanks for the replay Jagan.

I am checking your expression ,let you know once it matched.

Re: Problem in setanalysis

kaushiknsolanki — Mon, 29 Feb 2016 08:03:24 GMT

Dear Rajesh,

What the expression will give is like this.

It will give all the products where the count of ID is 1 and then count such Products.

Regards,

Kaushik Solanki

Re: Problem in setanalysis

Anonymous — Mon, 29 Feb 2016 09:37:24 GMT

Thanks it's working fina