Problem with Qlik expression

[sivaboggarapu20]

Hi All,

I have table in Qlik sense. The table contains customer, Start date, Expiry date and CBM value.

Before filtering any selections its showing 42.66 Values. But after I am making selection its showing 47.11(correct value )

After I filtering, I am getting correct value. Before filtering I am getting different value.Below is the expression I wrote.

Please let me know what is the wrong.

Sum({<[acct_dt]={">=$(=(Min(Date([Start Date of Rate Validity]))))<=$(=(Min(Date([Expiry Date of Rate Validity]))))"},[Product Code]={'OFREXP'},[Sub Product Code]={'OFLCL'}>}CBM)

Thanks,

Siva

[agigliotti]

what field selections do you mean ?

[shiveshsingh]

What are the selections?

[Anil_Babu_Samineni]

There is no wrong in your expression, But if you want to show same number which after selecting. We can look? May be share application to test the same

[sivaboggarapu20]

Hi,

I selected Customer(Abc) and TradeLine(US-IE)

Before Selection Customer- Abc, TradeLine-US-IE and CBM Values is 42.66

But After Selection with above - CBM value is giving 47.11(Correct Value)

Thanks,

Siva

[agigliotti]

why do you think Values 42.66 is wrong ?

[sivaboggarapu20]

Hi Anil,

Please look at the attachment

Thanks,

Siva

[sivaboggarapu20]

Hi Team,

If I hot code the above expression like below its working fine as expected

Sum({<[acct_dt]={">=$(=Date('05/01/2018'))<=$(=Date('04/30/2019'))"},[Product Code]={'OFREXP'},[Sub Product Code]={'OFLCL'}>}CBM)

But When I am writing like below its not working.. Please suggest me what would be the wrong

Sum({<[acct_dt]={">=$(=(Min(Date([Start Date of Rate Validity]))))<=$(=(Min(Date([Expiry Date of Rate Validity]))))"},[Product Code]={'OFREXP'},[Sub Product Code]={'OFLCL'}>}CBM)

Thanks,

Siva

[agigliotti]

maybe this:

Sum( {< [acct_dt] = {">=$(=Min(Date([Start Date of Rate Validity])))<=$(=Min(Date([Expiry Date of Rate Validity])))"},

[Product Code] = {'OFREXP'}, [Sub Product Code] = {'OFLCL'} >} CBM )

I hope it helps.

[sivaboggarapu20]

Hi Andrea,

Sorry, I am getting result like previously.

Thanks,

Siva