topic Selections in QlikView

Selections

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

Hi All .

Urgent help needed

i have a bar chart it will displays top5 and bottom leads and this is the expression iam using

=IF((Sum

(

{

Date= {">=$(StartDate)<=$(EndDate)"},

Department = P(Dept),

Brand=

} If(Leads=Replace(ValueList($(=Cust_LeadRankings__Desc),'',$(=Cust_LeadRankings_Asc)), Chr(11), ''), count)

)) > 0 , 0, 1) and Level= 1

when i make the selections accordingly i dont see any bar chart , and i take a list box of Brand in which i see the L is being selected as shown in the figure

and when i manually deseclt it as shown in the snapshot 2 i see the chart showing proper values .

Can someone help how do i edit this above expression so that the Brand shoul be highled in both possible values of Brand L and M.

Thanks in Advance

Re: Selections

sunny_talwar — Thu, 09 Mar 2017 10:43:23 GMT

May be this

=IF((Sum({<Date= {">=$(StartDate)<=$(EndDate)"}, Department = P(Dept), Brand=>} If(Only({<Brand>} Leads) = Replace(ValueList($(=Cust_LeadRankings__Desc),'',$(=Cust_LeadRankings_Asc)), Chr(11), ''), Only({<Brand>}count)) )) > 0 , 0, 1) and Only({<Brand>}Level) = 1

Re: Selections

smilingjohn — Thu, 09 Mar 2017 10:47:07 GMT

Let me try this sunny

Thanks

Re: Selections

smilingjohn — Thu, 09 Mar 2017 11:06:02 GMT

Hi Sunny i tried with your epression it says below error .

Re: Selections

sunny_talwar — Thu, 09 Mar 2017 12:11:00 GMT

Can you try just this

=IF((Sum({<Date= {">=$(StartDate)<=$(EndDate)"}, Department = P(Dept), Brand=>} If(Leads = Replace(ValueList($(=Cust_LeadRankings__Desc),'',$(=Cust_LeadRankings_Asc)), Chr(11), ''), count) )) > 0 , 0, 1) and Only({<Brand>}Level) = 1

Re: Selections

smilingjohn — Thu, 09 Mar 2017 12:22:03 GMT

HI sunny how do i edit the below expression for the same used case

Sum

(

{

Date= {">=$(StartDate)<=$(EndDate)"},

Department = P(Dept)

Brand=

} If(Lead=Replace(ValueList($(=Cust_LeadRankings__Desc),'',$(=Cust_LeadRankings_Asc)), Chr(11), ''), count)

)

it will be great if you can change this one .. the above expression seems to be working fine , but not able to makes changes in this

Re: Selections

smilingjohn — Thu, 09 Mar 2017 12:52:07 GMT

Hi I tried editing the expression in the anohter chart expression ..byt its giving an error like nested if is not allowed , THis is what i edited

=Sum

(

{

Date= {">=$(StartDate)<=$(EndDate)"},

Department = P(Dept)

Brand=

} If(Lead=Replace(ValueList($(=Cust_LeadRankings__Desc),'',$(=Cust_LeadRankings_Asc)), Chr(11), ''),only({<Brand>} count)

)

But this expression is giving nested if is not allowed