Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot tables. Needing some help.

I need to build a rank companies from sales value. In this same table I need to show the city, union and some numbers. In some cases the company has more than one information, city or union. How do I create a cell in that table where when I have more than one information has something like a list of related values ​​the company I select? I am trying for a long time and still can not. I'm trying to do this with pivot tables but i'm getting frustrating results.

2 Replies
Not applicable

Something like this eeeeee.png

When i click list open a list** of values related to te correspodent value of column one.


You can't click on a list to 'open' it. If you click on a value in an expression column then you select the dimension values of that row. It is possible to show/hide a table based on those selections. But there is no way to distinguish between clicking on a value in the CNPJ or City expression columns. See attached example.

talk is cheap, supply exceeds demand