topic Re: In straight table I want to add values dynamically through selection in QlikView

In straight table I want to add values dynamically through selection

Thu, 15 Sep 2011 10:11:14 GMT

Dear All,

I have a table Info which contains 2 fields

1.Name and

2.Value.

The fields contain values--

Header 1	Header 2
Name	Value
a	10
b	20

I want to create a straight table.In that table whenever I click on 'a' 10 comes.but

when we click 'b' 10+20=30 comes.How to do that?

Please give me an idea.

I am waiting here for your fast response...

what will be the expression?

Thanks & Regards,

Koushik.

In straight table I want to add values dynamically through selection

SunilChauhan — Thu, 15 Sep 2011 10:18:07 GMT

if(Name='a',Value,if(Name='b',sum( all Value)))

In straight table I want to add values dynamically through selection

Thu, 15 Sep 2011 10:40:14 GMT

Thanks for your reply Sunil.

But I want something more.If there are many name like a,b,c,d,e,f,g,h etc.

When I click on the forth/fifth or sixth name,automatically the previous

value including that selected name will come as a total.I dont want to write

a fixed code depending upon the names.It will be a dynamic expression.

Please help me out.

Thanks & Regards,

Koushik.

Re: In straight table I want to add values dynamically through selection

SunilChauhan — Thu, 15 Sep 2011 12:09:47 GMT

see the attached file hope this help

In straight table I want to add values dynamically through selection

Thu, 15 Sep 2011 13:44:20 GMT

Hi,

Try with the below Expression:

if(rowno()=1,Sum(Value),Sum(Value)+Above(Sum(Value)))

Regards,

Santhosh

In straight table I want to add values dynamically through selection

Fri, 16 Sep 2011 06:28:28 GMT

Thanks my dear friend.But your code do just a sum of two rows.I want a cumulative sum.

Is it possible in expression?

Please help me.

Thanks & Regards.

Koushik.

Re: In straight table I want to add values dynamically through selection

Fri, 16 Sep 2011 06:55:24 GMT

Hello,

I added a row number as RowNo to the table and use this for order and selection.

sum( {1 //use all datarows

< RowNo= //modifierer RowNo =

{ //

"< $(#=only(RowNo))", //select all rows before

"= $(#=only(RowNo))" //and the selected row

}

} Value )

P.S. The operator "<=" doesn´t work. Any ideas? ( "<= $(#=only(RowNo))" )

In straight table I want to add values dynamically through selection

Fri, 16 Sep 2011 07:37:04 GMT

Thanks everybody.