Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check the attached QVW. Not sure if this your requirement. If not, please provide a sample file which are working on
Regards,
Rakesh
hi
try apply to Enable Conditional
for CustomerState
SubStringCount(Concat(FieldName, '|'),'Costumer')
for StoreState
SubStringCount(Concat(FieldName, '|'),'Store')
Regards
Gernan
hi Gernan,
I tried that but for default it should show the total data right its not Coming
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
thank you Fabrice Let me give it a try