Solved: How to use variable in IF statement - Qlik Community

musketeers · ‎2016-03-08

Hi,

I have a variable in qlikview where I am calculating top 1 country.

Now I am using this variable to display the sales of each state for the country from the variable.

So if the variable name is vCountry.

I am using this statement in Dimension of Pie Chat:

If(country = $(vCountry), State)

But thsi is not working.

I need help in resolving this.

Please help me here.

Thanks

musketeers · ‎2016-03-09

Hi Avinash,

Thanks for your help.

I realized that I was doing wrong thing. My expression in variable was not working fine. I do not know why. Because when I use that variable in List Box, I was getting one value. But when I used that variable in Text Box, It was not showing any result.

Now I am using the below expression in my variable:

only(if(aggr(Rank(Sum([Sales Amt])),Country)=1,Country))

and I am getting country name in Text Box and List Box both. (THIS IS FOR TESTING THAT MY VARIABLE IS WORKING FINE)

Now I am using this variable as Sunny has suggested and am getting the result.

I am very thankful to all for your valuable time and suggestion.

View solution in original post

sunny_talwar · ‎2016-03-08

What about this:

If(country = vCountry, State)

pooja_sn · ‎2016-03-08

If(country = $(vCountry), State)

Should work. Check value of your variable. Can you share your qvw file..

musketeers · ‎2016-03-08

Hi Sunny,

Thanks for your help.

But it is not working.

Thanks

sunny_talwar · ‎2016-03-08

How is vCountry gets its value?

martinpohl · ‎2016-03-08

Hello,

change it into

If(country = '$(vCountry)', State)

Regards

Digvijay_Singh · ‎2016-03-08

Hope 'country' spelled correctly

musketeers · ‎2016-03-09

Hi Sunny, Yes, the variable vCountry is getting value from Country field only. It is dynamic value based on the other filter selection.

Now I want to compare this variable value with the Country Field and get the sum of sales for this country value.

musketeers · ‎2016-03-09

Hi Martin, when I am using this, I can see that qlikview is replacing '$(vCountry)' with the formula I have written in variable.

Ideally it should calculate the formula and then replace '$(vCountry)' with the result of formula. But this is not happening.

This is the rootcause why this is not working.

sunny_talwar · ‎2016-03-09

So if you are already making selection in Country field, I would expect this chart to drill down to only show states for the countries you have selected. Why do you need an if statement here?

How to use variable in IF statement

Related Topics