topic Change dimension based on a filter in QlikView

Change dimension based on a filter

Anonymous — Tue, 07 Nov 2017 08:54:17 GMT

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,

Re: Change dimension based on a filter

shraddha_g — Tue, 07 Nov 2017 08:58:49 GMT

create an Inline table with having field with dimension names.

Use that as a Filter and in Dimension use if(Getselectedcount(InlineFieldName) = 1,GetfieldSelection(InlineFieldName),DefaultDimension)

Re: Change dimension based on a filter

Anonymous — Tue, 07 Nov 2017 09:45:18 GMT

Sorry, I could not follow you.

I have 3 dimensions (division, region and territory), If I create a filter to select one of these dimensions, I want the table to show different measures for the selected metric.

Also, second question is how can I create such a filter? these three dimensions are 3 variables in my data. Can you please guide?

Re: Change dimension based on a filter

shraddha_g — Tue, 07 Nov 2017 10:02:35 GMT

Use Qlik Branch to give buttons for choosing Dimension.

Create a Variable vDim with values as division, region and territory and Labels as Division, Region, Territory respectively.

In Chart,

In Dimension, Use $(vDim) as Dimension

in Measure

Pick(wildmatch(vDim,'division','region','territory'),

Expression for division,

Expression for region,

expression for Terrirory

)

Re: Change dimension based on a filter

shraddha_g — Tue, 07 Nov 2017 10:08:38 GMT

In Load Script,

Load * Inline [

Dimemsion

Division

Region

Territory

];

In Front End,

Use Dimension Field from Inline table as Filter

In Chart,

In Dimension, if(getfieldselection(Dimension) = 'Division',$(division),

if(getfieldselection(Dimension) = 'Region',$(region),

if(getfieldselection(Dimension) = 'Territory',$(territory))))

In Measure,

if(getfieldselection(Dimension) = 'Division',Expression for Division,

if(getfieldselection(Dimension) = 'Region',Expression for Region,

if(getfieldselection(Dimension) = 'Territory',Expression for Territory)))

Re: Change dimension based on a filter

Anonymous — Tue, 07 Nov 2017 10:19:20 GMT

Thanks a lot for your response. I am pretty new to Qlik Sense and probably will take some time to implement it. I will get back to you with an update if this solves my purpose as soon as I am done. Thanks.

Re: Change dimension based on a filter

Anonymous — Tue, 07 Nov 2017 10:43:57 GMT

Can you guide me how should I write the expression for the created variable?

Re: Change dimension based on a filter

shraddha_g — Tue, 07 Nov 2017 10:45:49 GMT

What do you mean by created variable?

Re: Change dimension based on a filter

Anonymous — Tue, 07 Nov 2017 10:51:20 GMT

You asked me to create a variable vDim with values Division, Region and territory. I am not able to understand what expression to write to get the desired result.

Re: Change dimension based on a filter

Anonymous — Tue, 07 Nov 2017 10:54:38 GMT

I am not able to load the given code:

Load * Inline [

Dimemsion

Division

Region

Territory

];

I am getting the following error:

INLFED << 0435-a9d1-fc23-622c Lines fetched: 3

The following error occurred:

Unknown statement: binary

The error occurred here:

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

Re: Change dimension based on a filter

shraddha_g — Tue, 07 Nov 2017 10:55:32 GMT

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

Re: Change dimension based on a filter

Anonymous — Tue, 07 Nov 2017 11:10:51 GMT

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

Re: Change dimension based on a filter

shraddha_g — Tue, 07 Nov 2017 11:18:31 GMT

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

Re: Change dimension based on a filter

Anonymous — Tue, 07 Nov 2017 11:46:27 GMT

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

Re: Change dimension based on a filter

shraddha_g — Tue, 07 Nov 2017 11:48:45 GMT

Another option is using Inline table in Load Script

Re: Change dimension based on a filter

Anonymous — Tue, 07 Nov 2017 11:54:14 GMT

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

Re: Change dimension based on a filter

shraddha_g — Tue, 07 Nov 2017 11:59:12 GMT

That error is in Binary Statement.

Try putting Inline table after Binary statement

Re: Change dimension based on a filter

Chanty4u — Tue, 07 Nov 2017 12:01:20 GMT

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

Re: Change dimension based on a filter

Anonymous — Tue, 07 Nov 2017 12:20:13 GMT

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

];

Re: Change dimension based on a filter

Chanty4u — Tue, 07 Nov 2017 12:22:30 GMT

try to remove the singl quotes and try once