topic Select all in QlikView

Select all

n1ef5ng1 — Mon, 05 Aug 2013 03:25:16 GMT

Hi all,

I have this particular table where it will show the value if the 'Box' have dwell value in it.

I need to select ALL in this particular field call 'Tranship_Dwell' to give me the correct value in the table.

Is there any code that I can use to replace the current solution where user have to select ALL on the tranship_dwell field?

I tried if(Tranship_Dwell <> null(), sum(Expression))

i also tried if(Tranship_Dwell >= 0, sum(expression)

both gave me - value

Re: Select all

Mon, 05 Aug 2013 03:36:42 GMT

Hi,

If am not mistaken you would like to sum the value of the whole Tranship_Dwell dimension. If that is the case, I would suggest you create a Straight Table Chart, and in the Expression column add in an expression of Sum([Tranship_Dwell]).

By doing this, you wouldn't have to highlight the whole Tranship_Dwell dimension to produce the sum of the whole dimension. It will auto compute and show you the sum.

Hope this helps!

Best Regards,

Ram

Re: Select all

n1ef5ng1 — Mon, 05 Aug 2013 04:36:06 GMT

no is not, tranship_dwell is a condition whereby if it fulfills, it will therefore do an expression which is abit complex.

is not about summing up the total value of the tranship_dwell

Re: Select all

MayilVahanan — Mon, 05 Aug 2013 05:11:25 GMT

This can be achieved by

=sum({$<Tranship_Dwell = {'*'} >} Sales)

here {*} selects all values

= Sum(total Tranship_Dwell)

hope it helps