topic Re: set analysis help in QlikView

set analysis help

Tue, 01 Sep 2015 11:51:39 GMT

Can i use the below expression ?

sum({<TM>}[Square Feet])

here both TM and [Square Feet] are columns.

Re: set analysis help

sunny_talwar — Tue, 01 Sep 2015 11:52:19 GMT

Depends on what you are trying to do here?

Re: set analysis help

Kushal_Chawda — Tue, 01 Sep 2015 11:54:27 GMT

Yes you can use. Question is what you are trying to achieve?

Here it means, sum the [Square Feet] by ignoring selection of field TM

Re: set analysis help

sasiparupudi1 — Tue, 01 Sep 2015 11:55:30 GMT

Yes

sum({<TM>}[Square Feet])

sum({<TM=>}[Square Feet])

Re: set analysis help

Tue, 01 Sep 2015 12:24:11 GMT

I am trying to get the sum of [Square Feet] for TM

Re: set analysis help

Tue, 01 Sep 2015 12:24:32 GMT

I am trying to get the sum of [Square Feet] for TM

Re: set analysis help

Tue, 01 Sep 2015 12:24:37 GMT

I am trying to get the sum of [Square Feet] for TM

Re: set analysis help

sasiparupudi1 — Tue, 01 Sep 2015 12:28:12 GMT

Assuming that TM is a value of a dimension, you could use the following

sum({<YourDimension={'TM'}>}[Square Feet])

Re: set analysis help

Kushal_Chawda — Tue, 01 Sep 2015 12:31:15 GMT

do you mean all the values of TM?

Re: set analysis help

Tue, 01 Sep 2015 12:31:26 GMT

TM itself is a dimension.

Re: set analysis help

avinashelite — Tue, 01 Sep 2015 12:31:55 GMT

based on the selection of TM your sum of square Feet will get calculated ...

sum({<TM>}[Square Feet])

will give the total sum and it will not change according to the TM selection

sum([Square Feet])

this will give the total sum and it will vary according to the TM selection

i.e if

TM a has value 10 and b has values 20

then first expression when you select a or b it will always show the sum as 30

but if you go with second expression and if you make a as the selection in TM then sum will be 10..

Hope you got the difference

Re: set analysis help

sasiparupudi1 — Tue, 01 Sep 2015 12:33:54 GMT

sum({<TM={*}>}[Square Feet])

Re: set analysis help

Tue, 01 Sep 2015 12:37:06 GMT

THIS EXPRESSION SHOWS ERROR

Re: set analysis help

sasiparupudi1 — Tue, 01 Sep 2015 12:39:55 GMT

sorry

sum({<TM={'*'}>}[Square Feet])

Re: set analysis help

avinashelite — Tue, 01 Sep 2015 12:40:06 GMT

Did you check the explanation below

Re: set analysis help

Tue, 01 Sep 2015 12:41:04 GMT

I had to put the colon for the *.So,no error msg now.

sum({<TM={'*'}>}[Square Feet])

Thank you.It worked for me.Even with the error msg the answer was right.Thank you.

Re: set analysis help

Tue, 01 Sep 2015 12:41:40 GMT

Thank you very much for your help.I appreciate it.

Re: set analysis help

sunny_talwar — Tue, 01 Sep 2015 12:54:10 GMT

Just to add, I think this should also work:

=Sum({<TM=>}[Square Feet])

Re: set analysis help

Tue, 01 Sep 2015 13:58:13 GMT

Ya,that did work but was showing and error line.But the answer was correct.