topic Re: Calculated Dimension issue in Straight Table in QlikView

Calculated Dimension issue in Straight Table

Anonymous — Thu, 31 May 2018 13:27:02 GMT

Hi,

I have a straight table with multiple dimensions and a single expression, here I am trying to create a calculated dimension (Cust Number) to filter the data based on filter selection (Vehicle_Use). What I am trying to get is when we select a value (here LEASE) from Vehicle_Use filter then the straight table data along with the Cust Number filed should be filtered with two customer numbers only i.e. 699999,699998 and if we clear the filter which means if we don't select anything from the same filter it should display all the Cust Numbers in the straight table.

I have created a calculated dimension using below code to get what am looking, but its not working as expected, so i hope some one can help with below calculated dimension expression.

Calculated Dimension:

Aggr(Only({<Vehicle_Use={'LEASE'},Current_Cust_Number={'699999','699998'}>} Current_Cust_Number), Current_Cust_Number)

Expression:

=if(Vehicle_Use = 'LEASE',

count(DISTINCT{<Current_Cust_Number ={'699999','699998'}>}Unit_Number),

count(DISTINCT Unit_Number))

Re: Calculated Dimension issue in Straight Table

sunny_talwar — Thu, 31 May 2018 13:30:40 GMT

Since you are handling this in your expression, why do you need a calculated dimension? Why can't you just use Current_Cust_Number as your dimension?

Re: Calculated Dimension issue in Straight Table

Anonymous — Thu, 31 May 2018 13:55:58 GMT

Sunny,

What is happening with the above expression and Current_Cust_Numeber as dimension is, it is working fine when we select Lease from the filters but when we clear the filter straight table row count is not matching with my source system count.

So I tired to use a above cal dimension which is also not giving expected result and i have tried below expression as well, any thoughts?

=if(GetFieldSelections(Vehicle_Use='LEASE'), Count(DISTINCT{<Current_Cust_Number ={'699999','699998'}>}Unit_Number),

Count(DISTINCT Unit_Number))

Re: Calculated Dimension issue in Straight Table

sunny_talwar — Thu, 31 May 2018 15:27:20 GMT

Difficult to know what might be going on... are you able to share a sample where we can see this problem?

Re: Calculated Dimension issue in Straight Table

Anonymous — Thu, 31 May 2018 18:17:36 GMT

stalwar1‌ Please find the attached sample file

Re: Calculated Dimension issue in Straight Table

sunny_talwar — Thu, 31 May 2018 19:34:39 GMT

The if statement in your chart was wrong... try this

=if(GetFieldSelections(Vehicle_Use) ='LEASE'