Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to put dimensions of a straight table in a drop down list

Hi Everyone,

                    I need a straight table with different dimensions put in a drop down list, for example in my project I need Product, Customer and Country as dimensions of a straight table, but I don't want them to be displayed all at once, instead I need them to be put in a drop down menu(like a small icon at corner of the table), so that required dimension can be selected from drop down menu and that particular dimension must be displayed along with other expressions of the straight table. Please help me out if any of you have idea regarding this.

Thanks in advance!

venkysai

1 Solution

Accepted Solutions
MindaugasBacius
Partner
Partner

Try this:

Screenshot_1.jpg

If there is no hierarchy I would recommend using Cyclic group.

For Dimensions that are hierarchical use Drill down group.

After creating the Group you will find it in the Dimensions list. Just add it to the Straight table.

View solution in original post

8 Replies
florentina_doga
Partner
Partner

pls see this exemple

MindaugasBacius
Partner
Partner

Try this:

Screenshot_1.jpg

If there is no hierarchy I would recommend using Cyclic group.

For Dimensions that are hierarchical use Drill down group.

After creating the Group you will find it in the Dimensions list. Just add it to the Straight table.

View solution in original post

rgvavihs
Specialist
Specialist

Hi pfa

Not applicable
Author

u may need a pivot ver.

susovan_g
Partner
Partner

Hi Madhuri,

PFA

You can also try this example,

6.JPG

Not applicable
Author

Hello Mindaugas Bacius,

Thanks a lot, it worked exactly how I need.

MindaugasBacius
Partner
Partner

If you find the correct answer could you please close the thread by marking the correct and/or helpful answers.

Not applicable
Author

Sure!