topic Set Analysis in QlikView

Set Analysis

Fri, 20 Nov 2020 18:02:30 GMT

On selection of Year, Month (say, 2014,Jan) and Brand as WC01, i need to write set analysis as

Brand(WC01) value / Total Market Value of Wildcraft . with what expression i can achieve this?

Thanks

Re: Set Analysis

Thu, 22 Jan 2015 13:46:55 GMT

Hi Aditi,

Try this expression,

sum({<Brand = {"WC01"}>}Value)/sum({<Market = {"Wildcraft"}>})

Hope this helps.

Regards,

Snehal Nabar

Re: Set Analysis

Thu, 22 Jan 2015 13:54:58 GMT

Hey, thanks. i have written the same expression, it does work. But on selection of brand WR03, it should show me

value for brand / value for wrangler. ie1200/11700

I want to write a standard expression for selection of any brand

Re: Set Analysis

Thu, 22 Jan 2015 14:00:23 GMT

Hi,

I think you want to use

Sum(Total <Brand,Market> Value) / Sum(Total <Market> Value)

hope that helps

Joe

Re: Set Analysis

Fri, 23 Jan 2015 06:11:20 GMT

Well, I do want [sum(Value) for Brand / sum(Value) Market under which the same brand falls]

But how do i write an expression for this?

Re: Set Analysis

robert_mika — Fri, 23 Jan 2015 06:23:02 GMT

Could you attached your Excel data?

Re: Set Analysis

tyagishaila — Fri, 23 Jan 2015 06:41:27 GMT

Hi Aditi,

Plz try this

and let me know. If you don't get correct result, I will give you another solution.

sum(Total<Year,Month,Brand>Value)

sum(TOTAL<Market>Value)

Regards,

Shaila

Re: Set Analysis

Fri, 23 Jan 2015 07:29:10 GMT

Basically i want to calculate market share of the brand.

Re: Set Analysis

sunilkumarqv — Fri, 23 Jan 2015 07:35:28 GMT

What you actually want to achieve by default

In set analysis

Brand(WC01) value / Total Market Value of Wildcraft . will work alternatively other selections should trigger

Then you try like this ..

If(Getfeildselections(Brand)='WC01',sum({<Brand = {"WC01"}>}Value)/sum({<Market = {"Wildcraft"}>}),

sum(Value)/sum()))