topic Re: RE:Default selection in QlikView

RE:Default selection

Chanty4u — Thu, 11 Aug 2016 13:54:40 GMT

Hi all ,

I have small issue . i hve data like below

296.81

REQ:

Output: Witouht selection the result should be earliest month value :

Result 1/4/2015 =621 it should be reflect for only sum(opening balance)

Re: RE:Default selection

sunny_talwar — Thu, 11 Aug 2016 13:57:16 GMT

There are two reference No for 1/4/2015, you want to see both or just 1? How do you choose 40170162260? Also does the table need to change once you make the selections?

Re: RE:Default selection

Chanty4u — Thu, 11 Aug 2016 14:01:30 GMT

opening balance should be reflect..

1)when you select 1/4/2015 the value is sum(openg)=621

so the sam evalue should be displayed without any selections. [i.e: it should not be summed]

for 1/4/2015 -ref num 478761772

Re: RE:Default selection

Clever_Anjos — Thu, 11 Aug 2016 14:20:06 GMT

Please try

FirstSortedValue([Running Balance], [Value Date] )

Re: RE:Default selection

Chanty4u — Thu, 11 Aug 2016 14:23:47 GMT

Thnx clever . i will try and let you know

Re: RE:Default selection

sunny_talwar — Thu, 11 Aug 2016 14:26:39 GMT

ref number 478761772 has a running balance of 71.81? I am not sure what you want? May be this:

FirstSortedValue({<[Reference No] = {40170162260}>}[Running Balance], [Value Date])

Re: RE:Default selection

Chanty4u — Thu, 11 Aug 2016 14:32:05 GMT

thanks sunny its working.. let you know after checking with original data.

Re: RE:Default selection

sunny_talwar — Thu, 11 Aug 2016 14:33:19 GMT

Sounds good

Re: RE:Default selection

Chanty4u — Fri, 12 Aug 2016 05:36:18 GMT

thanks clever .Its working fine.

Thanks stalwar1 ur solution is also correct but not dynamic .