A scatter chart is for using numeric values as axes and plotting a numeric value.
If you want to just show your crosstable, use a pivot table chart.
In the script:
(ooxml, embedded labels, table is Sheet1);
Then in the UI, create a pivot table chart with dimensions UTILITIES and As, and =Only(Value) as expression
UTILITIES As A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12 A13 A14 A15 A16 A17 A18 A19 A20 A21 A22 A23 A24 CCCC + + + + ? ? - - - - - - - ? ? + + - - - - - - - ELE ? - - + ? - - + ? - + - - - ? - - + + - ? - + - MOB ? - + - - + ? ? - - - + ? - + - - + + + + - - - SSSS - - ? ? + + + - - - - - ? + + + + + - - - + + + WATE - ? - - - - - + + + ? ? ? ? + + + + - - - - - -
comm218055.qvw 148.2 K
although I think Stefan's solution using a pivot table should fit your requirements best, one solution using a grid chart instead could be:
hope this helps
QlikCommunity_Thread_218055.qvw 169.2 K
This looks nice, Marco!
Ranjani, note that a similar coloring and filtering can also be done using the pivot table chart, so it's really beneficial if you can tell us the real customer requirements as I asked for in your other thread:
You should be able to attach files, or at least post screenshots / images using the camera button in the editor tool bar.
To show you what I mean with coloring of a pivot table grid, have a look at
I am sorry my costumer requires excatlly way Marco has posted.
I saw the video which you had sent me in other thread but i m not getting use advanced options when i click on reply. that is the reason i could not upload any files
Ok, now at least & at last it's clear what your customer requires.
If you read through the very end of the document Sunny has created ('Uploading sample'), it's described that you won't have that advanced editor option from the INBOX.
"Just as a reminder that these options are only available when responding directly on the post. If you are responding from the message inbox from QlikView, you won't see the button for 'Use advanced editor'."
Hence you need to open the thread following the link of the thread, then the advanced editor should be available.
LOAD * FROM [https://community.qlik.com/servlet/JiveServlet/download/1045984-227555/Book1.xlsx] (ooxml, embedded labels, table is Sheet1);
b) Create grid chart with dimensions Type and UTILITIES
Background color attribute expression:
Set the style to the one on the upper left corner.
I think that's mostly it.
For the legend,copy the grid chart and replace the Type dimensions with a calculated
and the UTILITIES dimension with Value