Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Change dimension based on a filter

I want to change the dimension of table based on my filter selection. Is it possible to do so in Qlik Sense?  Please guide. Thanks.

Best Regards,

29 Replies
shraddha_g
Partner - Master III
Partner - Master III

if you have downloaded n used that extension mentioned in comment then drag n drop that extension on sheet.

In Right side, properties Panel, it will ask for Variable name. put it as vDim.

Later, in  Render as ->choose as Button

Click on add button .

give Division as Value also as Label.

Repeat this to create Region & Territory

Anonymous
Not applicable
Author

Actually, I am working on server, so I don't know if I can download any extensions there.

shraddha_g
Partner - Master III
Partner - Master III

You can download extension and From QMC you can import that extension to server if you have acess to QMC

Anonymous
Not applicable
Author

I do not think I have the access to import extension as the option is greyed out. Any other way to get the result?

shraddha_g
Partner - Master III
Partner - Master III

Another option is using Inline table in Load Script

Anonymous
Not applicable
Author

I tried using the code shared by you but was getting an error. I have shared the error above in the thread.

shraddha_g
Partner - Master III
Partner - Master III

That error is in Binary Statement.

Try putting Inline table after Binary statement

Chanty4u
MVP
MVP

binary statement always first line in the script  try to keep in first line

Anonymous
Not applicable
Author

Still facing the same error. The code I have used is as follows:

binary 'lib://gSonar DataModel (rnumdmas_qsadmin)/Model-gSonar Integrated.qvw';

Load * Inline [

Dimension

Division Name

Region Name

Territory Name

];

Chanty4u
MVP
MVP

try  to remove the singl quotes and try once