Syntax for using qsVariable to render chart based on button

[dreweezy]

Hi, I believe my previous thread was never uploaded. I am trying to grab the top 10 and bottom 10 values using the qsVariable.

Inside my variable for the top and bottom 10 I have:

I am trying to enter a syntax (using probably if statement) so that my bar chart will render based on when a user selects one of the buttons. 

I have something like but doesn't seem to work. 

if('$(vTopBot)'=1,num Sum({<ACCOUNT={"=Rank(Sum(SALES))<=10"}>},
if('$(vTopBot)'=2,num Sum({<ACCOUNT={"=Rank(-Sum(SALES))<=10"}>})
))

[R_Kaymakchiev]

Hi,

have you tried instead  of doing nested if statement, just a single one ?

The code should be something like this:

if(' $(vTopBot)'=1 ,num Sum({<ACCOUNT={"=Rank(Sum(SALES))<=10"}>} ,
    num Sum({<ACCOUNT={"=Rank(-Sum(SALES))<=10"}>}    )

[Channa]

i have similar post answered search for 

qsVariable to render chart based on newly created buttons