Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Group by on Straight Chart

Hi,

I have two callref fields in two different tables, one is in opencall table and only shows the call reference once.  The other is the updatedb table and everytime a call is updated it created the same callref number and adds the text.

I have joined the two tables and did a where statement where the callref = 233070, which obviously pulls through all the updates from the call so therefore I have 8 rows showing.

The unique field is called udindex, which is incremented by 1 everytime a new update is added.  Therefore what I want to do is do a groupby on the chart so it shows only one call reference but then being able to drill down to see all subsiquent updates on that call reference.

With Thanks

Jon Ditchfield

1 Solution

Accepted Solutions
jsaradhi
Valued Contributor

Re: Group by on Straight Chart

this should be easier in a pivot table...but since your post says it has to be a straight chart, did you try creating a group?

2 Replies
MVP
MVP

Re: Group by on Straight Chart

Can you provide little sample data for your question pls?

jsaradhi
Valued Contributor

Re: Group by on Straight Chart

this should be easier in a pivot table...but since your post says it has to be a straight chart, did you try creating a group?

Community Browser