Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Why Pivot table and Straight table are considers a chart?

I know mybe it is not the most Tecnical question that we are use to read and answer.

But i really wonder myself why QV "hidde" the "Straight table" and "pivot table" in Charts and even why it is consider a Chart?

In a the QV interview question

QlikView Interview Questions

What are the 6 chart types available in QlikView?

the correct Answer is :  Bar Chart, Pie Chart, Line Chart, Gauge Chart, Pivot table, Straight table.

But i would never said "Pivot table, Straight table"

Does anybody knows what this 2 tables are considers Charts ?

Thanks in Advance , Enrique

Labels (1)
1 Solution

Accepted Solutions
Not applicable
Author

Hello Enrique,

It is somehow answered in QlikView help:

Charts are graphical representations of numerical data. The pivot table and the straight table are special cases as they display the data in table form while retaining all the properties of a chart

Source: https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Pivot_Table.htm

View solution in original post

7 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Because they are all created with the same dialog window.


talk is cheap, supply exceeds demand
Not applicable
Author

Hello Enrique,

It is somehow answered in QlikView help:

Charts are graphical representations of numerical data. The pivot table and the straight table are special cases as they display the data in table form while retaining all the properties of a chart

Source: https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Pivot_Table.htm

swuehl
Champion III
Champion III

I am not a linguist nor an english native speaker, but it seems 'chart' is indeed not a wrong label here:

chart - Wiktionary

[...]

2. A systematic non-narrative presentation of data.

  1. A tabular presentation of data; a table.  [quotations ▼]
  2. A diagram.
  3. A graph.  [quotations ▼]

[...]

Not applicable
Author

I guess he is confused, because Table Box is a separate object, while Pivot / Straight Table are charts.

Then sentence form help (about shared properties) makes sense

Anonymous
Not applicable
Author

That exactly what i meant. Thanks for answer Jaku

Anders_Eriksson
Partner - Specialist
Partner - Specialist

Yes but Table Box is only a selection of fields in all possible permutations based on the selections while Straight Table and Pivot Table contains expressions that govern which dimensions are visibel.

Also every chart (be it linear graph, pie, gauge or whatever) can be converted to a straight table that is the base for all graphs data wise.

Anonymous
Not applicable
Author

Thanks a lot Anders for your knowlege contribution. !! i guess just the name make me confuse but thecnically you are right,

Best regards!!