topic Re: Set Analysis Required in QlikView

Set Analysis Required

varunvarma — Wed, 11 Feb 2015 10:02:16 GMT

Dear All,

Greetings!!!!

Please support to write set analysis in the expression. Please find the attached excel. I explained requirement in OUTPUT tab. I need to create a pivot table with two dimensions (MODEL, DIM) and one expression. Please support to create same. Thanks in advance.

Re: Set Analysis Required

anbu1984 — Wed, 11 Feb 2015 10:07:08 GMT

=COUNT(If(DOR = (DIM-1),VIN)

Re: Set Analysis Required

Wed, 11 Feb 2015 10:11:55 GMT

Hi,

Please have a look this one.

Thanks

Re: Set Analysis Required

alexandros17 — Wed, 11 Feb 2015 10:19:14 GMT

Here it is

Re: Set Analysis Required

Wed, 11 Feb 2015 10:30:52 GMT

Hi Varun,

Create a pivot chart with model and dim as dimension.

After creating chart, drag dim dimension to top of pivot chart.

PFA, it might help you.

Warm Regards,

Joshmi

Re: Set Analysis Required

robert_mika — Wed, 11 Feb 2015 10:31:41 GMT

Chart-->Pivot table

Expression:

SUM(IF(DOR=DIM-1,1))

Re: Set Analysis Required

varunvarma — Wed, 11 Feb 2015 10:50:09 GMT

Thank you Anbu.

Re: Set Analysis Required

varunvarma — Wed, 11 Feb 2015 10:50:37 GMT

Thank you all.