Linking Cycle Buttons

Tue, 20 May 2014 19:09:47 GMT

I have a table with two cycle buttons on it and I want to link them. They each have three choices: Paid, Billed, and Allowed (See above). I would like to have it where selecting paid in "Med Paid" causes the "Med _____ PMPM" to automatically change to paid. Can they be linked to cycle through the selections together?

Thank you for your help.

Re: Linking Cycle Buttons

swuehl — Tue, 20 May 2014 19:19:32 GMT

I don't think you can link your cyclic dimensions by a QV option.

But you can check the field you currently have cycled to in your first dimension using GetCurrentField( GroupName )

and then use a condition in your third dimension to switch fields, something like

=pick(Match(GetCurrentField( GroupName ), 'Med Paid','Med Billed', 'Med Allowed')

,[Med Paid PMPM]

,[Med Billed PMPM]

,[Med Allowed PMPM]

)

topic Re: Linking Cycle Buttons in QlikView

Linking Cycle Buttons

Re: Linking Cycle Buttons