topic Set Analysis Help in QlikView

Set Analysis Help

muniyandi — Wed, 02 Jul 2014 08:16:44 GMT

Hi All,

i need one help,i have more then 30 dimension filtration there in my qv doc.

below mentioned is my expression.

sum(total<Qtr,Region> Amount)

user apply the filter Qtr,Region time only this expression go to filter , otherwise i need sum(total<Qtr,Region> Amount) full value to be display.

i am trying

sum(total<Qtr,Region> {SubRegion=,City=............} Amount) , I follow up this method means,i will mention the all dimension value.

any Short cut available

Muni.

its_anandrjs — Wed, 02 Jul 2014 08:23:17 GMT

You are right but if in any expression you want to selection effect then you have to try like

sum( total<Qtr,Region> {1} Amount)

muniyandi — Wed, 02 Jul 2014 08:31:49 GMT

Thanks anand.

It's Working. some other case it's failing.

sum( total<Qtr,Region> {1} Amount) correct. One more thing. now i want filter only product dimension ,how to apply this expression.

Thanks,

Muni

its_anandrjs — Wed, 02 Jul 2014 09:05:00 GMT

This statement filter all dimensions

sum( total<Qtr,Region> {1} Amount)

You have to use

sum( {1} total<Qtr,Region> {<product= >} Amount)

sum( total<Qtr,Region> {<product= >} Amount)

Wed, 02 Jul 2014 09:28:30 GMT

sum(total<Qtr,Region>{<Product=>}Amount)