Need some help to present data in chart, can someone give some hint please

[gopal5879]

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

[Arthur_Fong · Accepted solution]

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

[Brett_Bleess · Accepted solution]

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

[gopal5879]

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

[gopal5879 · Accepted solution]

Brett,

 I was travelling, Sorry for the delay in getting back. Will let you know once I try out the solution. Thanks a lot