Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Averages in x,y chart

Hi,

I'm a bit of a QlikView newbie - so this might be quite obvious!

I have 20 different fields of about 200 records.  The 20 fields are 10 pairs of questions each pair showing the customer satisfaction and the importance of a particular aspect of a service.

I want to produce a point chart that plots the average satisfaction and the average importance for each of the 10 of questions.

I've no idea how to go about doing this in QlikView

Can anyone help?

Thanks,

Tim.

2 Replies
Highlighted
Esteemed Contributor

Re: Averages in x,y chart

Hi tim,

very welcome! Just split your table (using the function rowNo()) into one table for each type of question (two tables) - I think you can use the MOD() function to find out whether rowNo() is even or uneven.

HTH

Best regards,

DataNibbler

Highlighted
Not applicable

Re: Averages in x,y chart

Hi DataNibbler,

Thanks for getting back to me.

As I'm new to QlikView I htink I need more of a step by step guide.

In the attached spread sheet, I have the data in the form in Table 1

I guess I need to get it into the format in Table 2 (or maybe not?)

To produce the cart show.

I'm sure your suggestions were useful but I'm not sure how to go about using them!

Thanks again,

Tim.