Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dolly777
New Contributor III

Other filter selection should not effect the result?

Hi All,

If I select only [Seller Company Name] as a filter and any other filter selection should not affect the result  - that is my requirement   ,

So I writing the expression following way

If (if([Seller Company Name]= '$(VsellerCompany)',Rangesum(Above(sum({1<[FY and Quarter]={'FY17 Q4'},[Seller Company Name]={'$(=VsellerCompany)'}>}[Sales_ Amount]),0,Rowno())), Rangesum(Above(sum({1<[FY and Quarter]={'FY17 Q4'}>}[Sales_Amount]),0,Rowno())) )

But problem is that if I select only  [Seller Company Name] as a filter that time I get correct result but if I select  along with [Seller Company Name]    any other filter  it gives wrong result . Actually other filter also effect the results that is my issue


Thanks

Nirmala


5 Replies

Re: Other filter selection should not effect the result?

Hi Nirmala

I'm not sure about the purpose of the expression you have. Could you please explain little bit more and also tell us what is the value/Exp behind the VsellerCompany.

It could be better if you have provided a sample application or screenshots.

pradosh_thakur
Valued Contributor III

Re: Other filter selection should not effect the result?

what is the expression for VSellerCompany?

i guess alternate state will help you here.Put the required filter in a different state. calculate expression when the filter is selected in the alternate state else do the calculation in normal state.

hope this helps.

regards

Pradosh

dolly777
New Contributor III

Re: Other filter selection should not effect the result?

To store the selected value using alternate state

GetFieldSelction(Variable) ,if we use in variable overview window using alternate state it gives wrong result

pradosh_thakur
Valued Contributor III

Re: Other filter selection should not effect the result?

hi


GetFieldSelections ( field_name [, value_sep [, max_values] [ ,ALternate state]])


regards

Pradosh

Re: Other filter selection should not effect the result?

Would you be able to share a sample to show the issue?

Community Browser