set analysis with condition applied

[ronaldwang]

I have a dimension A which contains value say B, C ,D and I create a chart where I want to only show the amount for that dimension with B being selected. thus if user select C in the filter, the chart should show 0. what should be used?

[qlikviewwizard]

Hi,

Try like this.

SetAnalysis:

LOAD * INLINE [

A,Amount

B,10

C,20

D,30

];

[tresesco]

Or, may be using set analysis like:

Sum({<A*={'B'}>}Amount)

[manojkumar_mk]

HI,

Write in expression with set analysis:

Sum( {<A={'B'}>} amount)

Where,

A means Dimension,

B means parameter which is coming from Dimension

If you are taking Dimension as a filter and user select others selection in dimension the chart won't be reflect.

Thanks,

Manu