Have a look at the whats new in QlikView 11.qvw file.
Go to "Report" Tab and see if you are looking something like that.
Whats New in QlikView11.qvw 5.9 MB
Thanks Kaushik. I sort of understand whet is being shown there but it I copy it into my model nothing seems to happen.
LOAD * INLINE [_dimension
TAG FIELDS AccountStatus , $Dimension;
TAG FIELDS AccountType , $Dimension;
TAG FIELDS Agent , $Dimension;
TAG FIELDS Attorney , $Dimension;
TAG FIELDS DebtorIndex , $Dimension;
TAG FIELDS OwnerType , $Dimension;
TAG FIELDS ServiceGroup , $Dimension;
TAG FIELDS Township , $Dimension;
TAG FIELDS Ward , $Dimension;
TAG FIELDS IndigentStatus, $Dimension;
and then added Conditional Coding to the dimension, example
=SubStringCount(Concat(_dimension, '|'), 'AccountStatus')
Maybe I am just doing something stupid here or I am missing something someshere
The application contains the script work as well as some conditional options in charts.
I guess you have done the script part, now look in to the application for that chart and look for its property, under the property look at the dimension tab. You will find that all the dimensions are listed here and when you click on the dimension, you will find the enable condition option. This is the place where the conditions are written. Try to understand the condition statements and try to implement in your application.
It is the expression I have difficulty with
On chart properties - General - Calculation condition I have this
GetSelectedCount(bud_dimension_flag)<>' ' AND GetSelectedCount(bud_dimension_1)>0
Then on the first dimension I have this
=SubStringCount(Concat(bud_dimension_flag, '|'), 1)
I tried to change the expression different ways, finally got to this one, not sure if you can help me with the script. Not sure what I am doing wrong
if (GetSelectedCount(bud_dimension_flag)=' '
SubStringCount(Concat(bud_dimension_flag, '|'), 1),SubStringCount(Concat(bud_dimension_flag, '|'), 1))
I would like to get a solution using this, otherwise a hidden dimension could maybe help bt then you do not need the Calculation condition?