topic Re: Logic Help1 in QlikView

Logic Help1

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

Pls find the sample file and desired output in it, Pls suggest , totally stuck

Kushal_Chawda — Wed, 30 Mar 2016 08:17:37 GMT

What is expected output in excel? I am not able to open QVW

abhaysingh — Wed, 30 Mar 2016 08:18:41 GMT

Desired Output = if i select any date than that particular raw shud come and rest where date is blank shud come.

thanks

t_chetirbok — Wed, 30 Mar 2016 08:19:37 GMT

Hello!

if I understand your requirement, try to use this expression: sum({$+1<LinkDate={"-"}>}Qty)

Chanty4u — Wed, 30 Mar 2016 08:21:41 GMT

chk dis

Kushal_Chawda — Wed, 30 Mar 2016 08:26:14 GMT

try below expression

=sum({<LinkDate ={"$(=max(Date))"}> + <LinkDate-={"*"}> } Qty)

sunny_talwar — Wed, 30 Mar 2016 08:40:36 GMT

May be this:

Sum({$+<LinkDate = {'-'}>}Qty)

abhaysingh — Wed, 30 Mar 2016 08:50:11 GMT

Small Correction in the Data, LinkDate does not contain "-" in the Data.

So if i do not have "-" in the Data than what shud be the logic?

sunny_talwar — Wed, 30 Mar 2016 08:53:46 GMT

If it is truely null, then this:

Sum({$+<LinkDate = {"=Len(Trim(Only({<LinkDate>}LinkDate))) = 0"}>} Qty)

t_chetirbok — Wed, 30 Mar 2016 09:10:01 GMT

So, if your field LinkDate is null, you can try this expression:

sum({$}Qty)

+sum({1} if(isnull(LinkDate),Qty))