Levels with Table

[JustinDallas]

Hello Folks,

After sitting through the wonderful tutorials set found here (Working with Qlik NPrinting PixelPerfect reports) I've tried to create my own "Table through Levels" to no avail.  During the tutorial, we hear the tutorializer reference I believe "Sales vs Margin by Sales Rep".  In the Executive Dashboard, this is a Scatter Plot. 

I tried to repeat this with a straight table, but I don't see my table being listed in the "Add Fields" selection. The only items I see are F\*, and not O\*.

What concept about adding a table to a Detail Report band am I missing?  Any help is greatly appreciated.

[Ruggero_Piccoli]

Yes, simple straight tables can be added in Levels. In this case you'll have a row in the level for each row of the table.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[berryjulien2]

Once again, could you tell me with a straight table if there is any constraint like a calculated dimension.

I have some straight table unavailable as a level.

Thanks in advance for your answer    

[Ruggero_Piccoli]

Hi,

If you cannot see a specific straight table in the Levels node it means that the table is not suitable to be added. For example it has calculated dimensions.

Use only simple fields and the straight table should be visible.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[berryjulien2]

I deleted the equal sign