topic Re: Using variables in Straight table in QlikView

Using variables in Straight table

kashjaniqlik — Wed, 10 Aug 2016 16:30:03 GMT

Hello

I have a variable to do a sum of a field in my data model. The result is then split by another field in the column

For e.g. Sum of total customers. This is then split by countries.

UK - 500

US - 300

Total - 800

If I use a straight table with Countries as dimension and =SUM(totalcustomers) as expression, this works all OK.

If I then use a variable to store the sum of total customers and use this variable as expression, the straight table doesn't seem to split by countries. It shows the total customers for all countries.

UK - 800

US - 800

Please see attached.

Thanks

Re: Using variables in Straight table

sunny_talwar — Wed, 10 Aug 2016 16:54:35 GMT

Have you used the '=' when defining your variable? Try '=Sum(totalcustomers)' vs 'Sum(totalcustomers)'

Re: Using variables in Straight table

mphekin12 — Wed, 10 Aug 2016 16:57:08 GMT

Can you post a sample of your app?

Re: Using variables in Straight table

maxgro — Wed, 10 Aug 2016 18:25:07 GMT

try to read here

The Magic of Variables

Re: Using variables in Straight table

kashjaniqlik — Thu, 11 Aug 2016 08:15:28 GMT

Hi Sunny

Yes all variables are defined with an "=" sign.

SET vTotalCustomers = '=SUM(TotalCustomers)';

Thanks

Re: Using variables in Straight table

kashjaniqlik — Thu, 11 Aug 2016 08:41:52 GMT

Thanks Massimo‌

Re: Using variables in Straight table

maxgro — Thu, 11 Aug 2016 08:42:35 GMT

try with one of

Set vTotalCustomers = Sum(TotalCustomers) ;

Let vTotalCustomers = 'Sum(TotalCustomers)' ;

and then as expression in chart

$(vTotalCustomers)