Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
DataScem
New Contributor II

Show disaggregated information in chart lines

Hello all, I have a very basic question. How can I represent in a line chart disaggregated data for each sales person by product sold instead of having it all aggregated? I am attaching some pictures of my data set and chart and attaching the data set. Thanks!


Chart 1.JPGAggregated data from QlikChart 2.JPGData set example

4 Replies
Channa
Contributor III

Re: Show disaggregated information in chart lines

just add one extra row like ID

and concatenate ID&Salesman

 

Channa
DataScem
New Contributor II

Re: Show disaggregated information in chart lines

Thanks for your reply, Channa. How do I do this exactly? Sorry but I am totally new to Qlik.

Channa
Contributor III

Re: Show disaggregated information in chart lines

Just add RECNO() as ID while loading

 

after ur lie chart dimension

 

ID&SalesMan

Channa
DataScem
New Contributor II

Re: Show disaggregated information in chart lines

Thanks, I will try that