topic Re: set analysis with condition applied in QlikView

set analysis with condition applied

ronaldwang — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: set analysis with condition applied

qlikviewwizard — Thu, 14 Jun 2018 04:58:27 GMT

Hi,

Try like this.

SetAnalysis:

LOAD * INLINE [

A,Amount

B,10

C,20

D,30

];

Re: set analysis with condition applied

tresB — Thu, 14 Jun 2018 05:19:21 GMT

Or, may be using set analysis like:

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

Re: set analysis with condition applied

manojkumar_mk — Thu, 14 Jun 2018 05:27:20 GMT

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