Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Output is desired as below in chart | ||||
History Type | ProviderId/Tin | Closures | ||
BLIST Total | 474701392 | 3 | ||
Total | 474701392 | 5 | ||
BLIST | 998780 | 3 | ||
Not BLIST | 123758 | 2 | ||
Data is avalilable as below | ||||
Tin | ProviderId | claimsclosure | BLIST | NOT BLIST |
474701392 | 998780 | 1 | 1 | |
474701392 | 998780 | 1 | 1 | |
474701392 | 998780 | 1 | 1 | |
474701392 | 123758 | 1 | 1 | |
474701392 | 123758 | 1 | 1 | |
There you go:
First, you need to pivot this table into QV readable table structure.
Next, load the Tin data into a new table, add in a new flag for front end usage.
Do the same to ProviderId data, these two tables will be concatenated together at the end as they have the same columns.
Lastly, create History Type table to store the row values(BLIST Total, Total, BLIST, Not BLIST).
Refer qvw attached as reference.
Thanks and regards,
Arthur Fong
Gopal, did Arthur's sample app get you what you needed? If so, do not forget to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know this worked for you. If you are still working on things, please leave an update.
Regards,
Brett
Brett,
I was travelling, Sorry for the delay in getting back. Will let you know once I try out the solution. Thanks a lot
There you go:
First, you need to pivot this table into QV readable table structure.
Next, load the Tin data into a new table, add in a new flag for front end usage.
Do the same to ProviderId data, these two tables will be concatenated together at the end as they have the same columns.
Lastly, create History Type table to store the row values(BLIST Total, Total, BLIST, Not BLIST).
Refer qvw attached as reference.
Thanks and regards,
Arthur Fong
Gopal, did Arthur's sample app get you what you needed? If so, do not forget to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know this worked for you. If you are still working on things, please leave an update.
Regards,
Brett
Aurthur,
Let me try out the solution. thanks a lot for your help. I was travelling, Sorry for the delay in getting back. Will let you know
Brett,
I was travelling, Sorry for the delay in getting back. Will let you know once I try out the solution. Thanks a lot