topic Re: Cycling Multiple expressions in QlikView

Cycling Multiple expressions

Thu, 04 Oct 2012 15:09:57 GMT

Is there a way to cycle multple expressions at the same time? I have a tabular chart with thirteen columns, one for the customer name (the dimension), and one expression for each month. I'd like to be able to cycle from dollars to units in all twelve months simultaneously. Can this be done?

Re: Cycling Multiple expressions

m_woolf — Thu, 04 Oct 2012 15:32:07 GMT

Write each expression something like this:

if(vExprFlag = 1, sum(Dollars),sum(Units))

Create a variable vExprFlag and set to 1.

Create a button that cycles the value of the variable between 1 and 0 when clicked.

Re: Cycling Multiple expressions

Thu, 04 Oct 2012 15:44:17 GMT

What mwoolf has suggested will work. Another idea is to have a list box that contains 'Dollars' and 'Units', and the user can select which view they want to see. See attached.

Re: Cycling Multiple expressions

Thu, 11 Oct 2012 15:23:35 GMT

Thanks. That worked. As did Rebeccad's suggestion.

Next question: Is it possible to change the column formatting
dynamically from integer to money when I make the switch?

Also, is there a good reference on the API? I looked at
the API Guide.qvw but it looks pretty lame. I have a VB
background but I'd like to find out more about the classes, properties
and methods available.

Re: Cycling Multiple expressions

Thu, 11 Oct 2012 15:24:55 GMT

Thanks. That worked. As did Rebeccad's suggestion.

Next question: Is it possible to change the column formatting
dynamically from integer to money when I make the switch?

Re: Cycling Multiple expressions

MayilVahanan — Thu, 11 Oct 2012 15:28:28 GMT

Try like this

if(vExprFlag = 1, Num(sum(Dollars),'$#,##0.00'),Num(sum(Units)),'#,##0'))

And Number format , select as Expression Default.

Hope that helps

Re: Cycling Multiple expressions

Thu, 11 Oct 2012 15:28:48 GMT

Thanks. That worked. As did Rebeccad's suggestion.

Next question: Is it possible to dynamically change the column formatting from integer to money when the switch from units to dollars occurs?

Also, is there a good reference for the API? I looked at the API Guide.qvw but it seems pretty lame. I'd like to get a better handle on the classes, properties and methods available.