Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot and Table box problem

Hi!

I've a problem which i think is pretty simple to solve.

I've made a pivot table and want to display some data from a table which helds both numeric and text using an expression. The table name is VALUE so i just wrote VALUE in the expressen.

But the pivot will only show a "-" if i preview the table in table viewer i can see all the data and also if i just put it in a listbox but not in a pivot or tablebox.

Any suggestions?

//BR
Patrik

1 Solution

Accepted Solutions
Not applicable

Pivot and Table box problem

Hehe I'm so sorry guys, it was me, i linked the tables with the wrong data.

So now it works as i want


//BR
Patrik

7 Replies
Not applicable

Pivot and Table box problem

Please put the expressions you are using to calculate the table or attached the .qvw so we can help.

Thank you. Greetings.

Not applicable

Pivot and Table box problem

There isnt any expression calculated, I've onyl typed VALUE in the expression to show the data.

I'll put in a screen.

exp.jpg

Not applicable

Pivot and Table box problem

You have specified that VALUE is a table name. Is it a column name instead?

Pivot requires a dimension and a measure to display the output, else it will not show any value.

Please include a dimension like date or so and you can see the result in the Pivot

Hope this helps.

- Karthikeyan

Not applicable

Re: Pivot and Table box problem

Hi,

In the expression you should give the column name insteadof table name.

Regards

.........

srikanthsri1
Valued Contributor

Re: Pivot and Table box problem

look for the dimension or else create list box and select those fileds from list box u might see some thing

Not applicable

Pivot and Table box problem

expression need to indicate what you want to do, example:

have a table with all sales of your company, the table contains the fields

seller

branch

product

amount

If you want to know how much each salesperson sold by Seller and Product then Seller and Product will be your two dimensions and your expression will be the sum of the amount of each product sold, in this case:

Sum (Amount)

However if you just want to show the raw data from your table, simply use a box chart table where you need not put any expression simply shows all the fields in the table of your choice.

Sorry for my bad english.

Regards.-

Not applicable

Pivot and Table box problem

Hehe I'm so sorry guys, it was me, i linked the tables with the wrong data.

So now it works as i want


//BR
Patrik

Community Browser