Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

gopal5879
New Contributor III

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

Output is desired as below in chart
History TypeProviderId/TinClosures  
BLIST Total4747013923  
Total4747013925  
BLIST9987803  
Not BLIST1237582  
     
     
Data is avalilable as below
     
TinProviderIdclaimsclosureBLISTNOT BLIST
47470139299878011 
47470139299878011 
47470139299878011 
4747013921237581 1
4747013921237581 1
     
3 Solutions

Accepted Solutions
Partner
Partner

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

There you go:

MC.PNG

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

 

  

 

 

View solution in original post

Support
Support

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

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

gopal5879
New Contributor III

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

Brett,

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

View solution in original post

4 Replies
Partner
Partner

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

There you go:

MC.PNG

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

 

  

 

 

View solution in original post

Support
Support

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

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

Highlighted
gopal5879
New Contributor III

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

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
New Contributor III

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

Brett,

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

View solution in original post