Can we use set modifiers in dimension in case of a chart?

[#1]

Hello Frns,

can i use set modifiers to use only some values from a field in a dimesion of chart?

Like if i have a table:

Table1

         B1     B2        B3

A1     200     300     400

A2     500     600     700

A3     800     900     1000

Where(A1,A2,A3) belongs to field A and (B1,B2,B3) belongs to field B and the crresponding values is C

I want to make a chart whose dimension contains only B2 and B3 expession will based on C field and the purpose is making a graph for A1 for its values B2 and B3,

How can i do it?

Thanks.

[MayilVahanan]

Hi

If my understanding is correct, you need as result like this

          B2      B3

A1     300     400

If so,

Try like in expression

=Sum({<A = {'A1'}, B= {'B2','B3'}>}C)

Hope it helps

[#3]

Use the following expression to achieve your goal.

sum( {<A={'A1'},B={'B1','B2'}>} C)

Hopefully this helps.

[#4]

Hii All,

The above table is my pivot chart.I want to open a barchart for particular selection from field A.

where i used B as dimension but i don't want to show B1 for any graph.

I am using this expression for the chart

sum( {<A=GetCurrentSelections(A),B=B-{B1}>}C)

this expression is not working.

[jonathandienst]

Hi

The A=GetCurrentSelections(A) is redundant as this is QV's default behaviour (and is not valid set syntax), so your expression should be:

sum( {<B={'*'}-{'B1'}>} C) or

sum( {<B-={'B1'}>} C)

Regards

Jonathan

[MayilVahanan]

Hi

Try like this

sum( {<B-={'B1'}>} C)