Hi Community Members,
Can we create a radio button in qlikview? Let me give you an example of what I am trying to achieve, I have a field called Returns code as shown below:
Returns Code |
ABC |
DEF |
GHI |
JKL |
MNO |
PQR |
XYZ |
And also a field called Department which has three field values called Sales, Finance and Services. So, my requirement is I want to have all three field values available for all the Returns Code and once the Department value is selected, for example once you select Finance for ABC after that all three options should be available for DEF and so on. Is this possible to achieve? Also, I have tried using alternate states but it does not work I am trying to achieve that for every Returns Code there should be all three departments available which the user can select without effecting other selections in Returns Code.
Given below is the table I am trying to achieve with radio buttons in Finance, Sales and Services
Returns Code | Total |Department | Finance | Sales | Services |
ABC | 100 | | | |
DEF | 200 | | | |
XYZ | 300 | | | |
HJK | 500 | | | |
Once the selection is made in radio button the below should be the result.
Result:
ABC | Finance | 100 |
DEF | Sales | 200 |
XYZ | Services | 300 |
Thanks for all the help in advance.
Regards,
Don
