topic Re: Qlikview table in QlikView

Qlikview table

Wed, 14 May 2014 15:57:36 GMT

Hi all, I wonder if you ever wanted to create a table, where you want to define the row name(instead of using dimension), and the value for it. For example: in the following table I have 3 columns, 1st column is the row name, 2nd column is 1st value of that row, 3rd column is 2nd value of that row.

The row name need to be labeled arbitrarily, not by selected dimensions. It's basically like an excel table where you are put in row name and calculated values.

Does qlikview offer any tables like this?

Row name	Value1	Value2
Booked FY14 Tour	2978	2978
Conv. Rate of FY14 Tours	3.64%	3.64%
Booked FY15 Tour	890	890
Conv. Rate of FY15 Tours	1.09%	1.09%
Booked Y16 Tour	37	37
Conv. Rate of FY16 Tours	0.05%	0.05%

thanks very much for the help!!!!

Xuan

Re: Qlikview table

Joseph_Musekura — Wed, 14 May 2014 17:41:12 GMT

Hi,

Can you check the "crosstable" in QlikView reference manual?

Does the definition of crosstable answer to your question?

See attached sample

Re: Qlikview table

Peter_Cammaert — Wed, 14 May 2014 20:15:38 GMT

Sort of a Metrics table, where every row may have a different formula? Cannot be done in a simple generic way. You could construct a huge IF statement that selects specific formulas for specific dimension values, but I guess that's not really what you want (difficult to expand or maybe formulas should be configurable by way of an external listing)...

Quite a lot of community members (including myself) hit the wall a couple of times trying to create a very useful feature like this. It seems that QlikView's associative technology does not allow this kind of construct.