topic Dynamic Dimensions using IF() in QlikView

Dynamic Dimensions using IF()

Thu, 03 Oct 2013 09:18:22 GMT

Hi,

I am new to qlikview, I was trying to create a dashboard where i created a Dimension table using Inline load.

now my entire dash board should be dynamic to the user.

i.e. IF the user select's Store it should show the Store details in the KPI

if the user selects Customer it should show the Customer details in the KPI else it should be the total value.

I have 2 different Dimensions i.e state

1.CustomerState

2.StoreState

i used Calculated dimensions

IF(

Dimentions='Store','StoreState',

If(

Dimentions='Customer','CustomerState',

))

Now how to combine both the states inorder to see the total

plz help guys...

Thanks in Advance

Re: Dynamic Dimensions using IF()

Thu, 03 Oct 2013 09:40:56 GMT

Check the attached QVW. Not sure if this your requirement. If not, please provide a sample file which are working on

Regards,

Rakesh

Re: Dynamic Dimensions using IF()

Thu, 03 Oct 2013 09:57:21 GMT

Re: Dynamic Dimensions using IF()

Thu, 03 Oct 2013 10:07:30 GMT

try apply to Enable Conditional

for CustomerState

SubStringCount(Concat(FieldName, '|'),'Costumer')

for StoreState

SubStringCount(Concat(FieldName, '|'),'Store')

Regards

Gernan

Re: Dynamic Dimensions using IF()

Thu, 03 Oct 2013 10:38:03 GMT

hi Gernan,

I tried that but for default it should show the total data right its not Coming

Re: Dynamic Dimensions using IF()

Thu, 03 Oct 2013 10:51:09 GMT

Hi,

Perhaps sth like:

1) create a variable that will be populated with Customer State, Store State or Null according to the Dimentions chosen

2) The dimension of the chart will appear if that variable is not NULL (Dimension tab, Enable Condition)

3) Expression

if(variable is null, sum(VALUE), aggr(VALUE, $Dimentions or $TheVariable [I do not know what are the field name])

Fabrice

Re: Dynamic Dimensions using IF()

Thu, 03 Oct 2013 10:55:11 GMT

thank you Fabrice Let me give it a try