topic Re: Calculated dimensions? in QlikView

Calculated dimensions?

Wed, 25 Jan 2012 11:33:24 GMT

Hello,

I have a chart with some data, but i need to convert that table in 3 tables, everyone with data from the respective type (without changing the selections).

In the bellow example i want to create 3 charts, one for the 'segmento' 1, other for the 'segmento' 2 and finaly another to 'segmento 3.

Segmento	Familia	Qty	Price
1	Bebidas	5.163	0,01
1	Carne de Bovino	39.959	0,05
1	Carne de Ovino	816	0,01
2	Bebidas	2.273	0,01
2	Carne de Bovino	66.794	0,06
2	Carne de Ovino	209	0,01
3	Bebidas	327	0,01
3	Carne de Bovino	1.117	0,05
3	Carne de Ovino	69	0,00

My actual object/chart has to dimensions: 'Segmento' and 'Familia', i want to 'filter' the dimension 'Segmento' in order to show only data from just one 'Segmento' in each one of the charts, maybe use some calculated dimension like: { <[Segmento] = {1} >}.

So if, as in the above example, i have 3 'Segmentos' i'll do a chart (each one with its calculated dimension) for each one of the 'Segmentos', see the bellow example.

Segmento	Familia	Qty	Price
1	Bebidas	5.163	0,01
1	Carne de Bovino	39.959	0,05
1	Carne de Ovino	816	0,01

Segmento	Familia	Qty	Price
2	Bebidas	2.273	0,01
2	Carne de Bovino	66.794	0,06
2	Carne de Ovino	209	0,01

Segmento	Familia	Qty	Price
3	Bebidas	327	0,01
3	Carne de Bovino	1.117	0,05
3	Carne de Ovino	69	0,00

Is this Possible?

Thank you,Joaquim

Calculated dimensions?

swuehl — Wed, 25 Jan 2012 11:39:35 GMT

Joaquim,

try using the set expression like { <[Segmento] = {1} >} in all your expressions, using aggregation functions.

E.g.

sum( { <[Segmento] = {1} >} Qty)

to create the first chart.

Hope this helps

Stefan

Re: Calculated dimensions?

Wed, 25 Jan 2012 11:42:46 GMT

Thank you Stephan.

That would be the obvious way, but that way the other segmentos would appear also but with 0 values.

Cumprimentos,

Joaquim Correia

Sistemas de Informação

Tel.: (351) 220 403 243 / 00 • Fax: (351) 229 022 107

Tlm.:(+351) 919 112 623 • e-mail: joaquim.correia@b2b-pt.com<mailto:luis.ferreira@b2b-pt.com>

De: swuehl

Enviada: quarta-feira, 25 de Janeiro de 2012 11:40

Para: B2B-Joaquim Correia (Informática)

Assunto: - Re: Calculated dimensions?

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Calculated dimensions?

created by swuehl<http://community.qlik.com/people/swuehl> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/185449#185449

Calculated dimensions?

swuehl — Wed, 25 Jan 2012 12:23:46 GMT

The other dimension values won't appear if suppress zero values is enabled on presentation tab.

You could also try a calculated dimension like

=if (Segmento=1,Segmento)

=aggr(if(Segmento=1,Segmento),Segmento)

=aggr(only({<Segmento={1}>} Segmento),Segmento)

and check Suppress When Value is Null on dimension tab.

Calculated dimensions?

stephencredmond — Wed, 25 Jan 2012 12:33:46 GMT

In the Dimension, you can simply do a calculation:

=if(Segmento=1, Segmento, Null())

Then supress Null for the dimension.

Regards,

Stephen

Re: Calculated dimensions?

Wed, 25 Jan 2012 13:05:57 GMT

In the Used Dimensions, Add the following "Calculated Dimension"

=if(Segmento=1, Segmento)

Then on the "Setting for Selected dimensions" area, Check the button "Suppress when value is Null"

Kind Regards.

Re: Calculated dimensions?

Wed, 25 Jan 2012 15:20:50 GMT

Thank you Quentin.

It was it.

Cumprimentos,

Joaquim Correia

De: Quentin Richard

Enviada: quarta-feira, 25 de Janeiro de 2012 13:06

Para: B2B-Joaquim Correia (Informática)

Assunto: - Re: Calculated dimensions?

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Calculated dimensions?

created by Quentin Richard<http://community.qlik.com/people/biteguebiessono> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/185480#185480

Re: Calculated dimensions?

Wed, 25 Jan 2012 15:21:26 GMT

Thank You Stephen.

Cumprimentos,

Joaquim Correia

De: Stephen Redmond

Enviada: quarta-feira, 25 de Janeiro de 2012 12:34

Para: B2B-Joaquim Correia (Informática)

Assunto: - Re: Calculated dimensions?

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Calculated dimensions?

created by Stephen Redmond<http://community.qlik.com/people/stephen.redmond> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/185477#185477

Re: Calculated dimensions?

Wed, 25 Jan 2012 15:21:26 GMT

Thank you Swuehl.

Cumprimentos,

Joaquim Correia

De: swuehl

Enviada: quarta-feira, 25 de Janeiro de 2012 12:24

Para: B2B-Joaquim Correia (Informática)

Assunto: - Re: Calculated dimensions?

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Calculated dimensions?

created by swuehl<http://community.qlik.com/people/swuehl> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/185474#185474