topic Re: Several dimension values belonging in calculated dimension in QlikView

Several dimension values belonging in calculated dimension

Thu, 29 Sep 2011 09:21:19 GMT

Hi all,

Here is the context. I have several projects, associated to a current phase. Each phase belongs to one or two categories, Development or Clinical (Dev_Flag and Cli_Flag). I have this set of data :

Project	Phase	Dev_Flag	Cli_Flag
Prj_1	Ph_1	Y	N
Prj_2	Ph_2	Y	Y
Prj_3	Ph_3	N	Y
Prj_4	Ph_2	Y	Y
Prj_5	Ph_1	Y	N

I would like to display on a bar chart, the repartition of my projects by Phase and type of Phase (Development or Clinical). So, I've made a calculated dimension to build my two categories :

=If (Dev_Flag = 'Y', 'Development', If (Cli_Flag = 'Y', 'Clinical'))

Problem is that "If" condition is exclusive. Ph_1 and Ph_2 belong to both categories but are displayed only in the first encountered category in "If" Statement. Look at the attached example.

How can I make related projects appear in both category ?

Thanks,

Julien

Several dimension values belonging in calculated dimension

SunilChauhan — Thu, 29 Sep 2011 09:45:47 GMT

I belive ph_1 not included in Cli flag

if you see closely there is only N value for CLI flag

so Ph_1 will not appear in CLi category

Re: Several dimension values belonging in calculated dimension

kaushiknsolanki — Thu, 29 Sep 2011 09:47:34 GMT

Hi,

I think you need one more value i.e. Both. Meaning the Project Names which falls in both the category Development and Clinical.

Have a look at the example attached.

Regards,

Kaushik Solanki

Several dimension values belonging in calculated dimension

Fri, 30 Sep 2011 08:53:03 GMT

Hi !

First of all, thanks for your answers.

Sunil, I'm sorry, I don't understand your note. Ph_1 is not included in Clinical bar because of the Cli_Flag value (equals to N). It's what I expect. Problem is about Ph_2 that is only displayed in Development bar despite Cli_Flag value equals to Y.

Kaushik, attached example is mine. You've probably sent the wrong file. By the way, I've add a both flag but problem remains the same. In "If" statement, if the first condition is checked, the second is ignored. A same value can't appear in both bar.

Regards,

Julien

Re: Several dimension values belonging in calculated dimension

kaushiknsolanki — Fri, 30 Sep 2011 09:31:35 GMT

Hi,

Sorry for wrong file.

Please have a look at the attached file.

Regards,

Kaushik Solanki

Re: Several dimension values belonging in calculated dimension

Fri, 30 Sep 2011 09:36:24 GMT

Hi! Try like this.

Several dimension values belonging in calculated dimension

Fri, 30 Sep 2011 13:04:49 GMT

Very interesting tip KostinSergey, it works fine ! Thanks Kaushik for your answer but Kostin's one is exactly what I expected.

Thanks for your time everybody !

Regards,

Julien