topic Variables and where are variables used in QlikView

Variables and where are variables used

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

Hi All,

I'm new to Qlikview.I wish to know that what are variables and where variables are used in Qlikview.Please provide some examples.

If you know any link on this please share it.Your help will be greatly appreciated.

Regards,

Sivarama

Re: Variables and where are variables used

isorinrusu — Fri, 09 Mar 2018 09:39:13 GMT

Hi Sivarma,

Quick intro: variables store mostly expressions (like sum(Sales), but can also contain texts, colors, a combination of other expressions, fields, etc. The point of using variables for expression is reusability, and also improves performance.

Quick use case: you have in 4 different charts a sum of Sales by category, department, product and country. Instead of using sum(Sales) in each of them, you can put the expression in a variable and use $(vSales) for all charts. If the expression changes to sum(Sales)+sum(Returns), you will only have to change the variable, not the expression in your 4 different charts.

That's just one use case among hundreds.

Hope it helps,

Sorin.

Re: Variables and where are variables used

Anonymous — Fri, 09 Mar 2018 09:44:35 GMT

Hi Sorin,

Thanks for the quick response.

The information about variables is really helpful,I'm actually looking for an overview about variables which will help in interviews.

Regards,

Siva