topic Re: Why Pivot table and Straight table are considers a chart? in QlikView

Why Pivot table and Straight table are considers a chart?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Why Pivot table and Straight table are considers a chart?

Gysbert_Wassenaar — Mon, 06 Feb 2017 19:02:36 GMT

Because they are all created with the same dialog window.

Re: Why Pivot table and Straight table are considers a chart?

Mon, 06 Feb 2017 19:04:18 GMT

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

Re: Why Pivot table and Straight table are considers a chart?

swuehl — Mon, 06 Feb 2017 19:08:35 GMT

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.

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

[...]

Re: Why Pivot table and Straight table are considers a chart?

Mon, 06 Feb 2017 19:14:21 GMT

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

Re: Why Pivot table and Straight table are considers a chart?

Anonymous — Tue, 07 Feb 2017 08:17:07 GMT

That exactly what i meant. Thanks for answer Jaku

Re: Why Pivot table and Straight table are considers a chart?

Anders_Eriksson — Tue, 07 Feb 2017 08:35:50 GMT

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.

Re: Why Pivot table and Straight table are considers a chart?

Anonymous — Tue, 07 Feb 2017 09:20:55 GMT

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

Best regards!!