If you download the What's New in Qlikview 11 demo qvw you can see how it's done. In the script on the tab Tags you can find the load statement that creates the _dimension field with the names of the dimensions users can select for the report. The report itself contains all these dimensions, but uses conditional expressions to show or hide them based on the selections in _dimension. That's all there's to it: a field to make selections in and expressions that use the selections to determine which columns are shown. If you want another example qvw search for testselectfromstring.qvw here on the forums. It uses the same technique.
I am not able to understand how this is working as i am a designer not a developer. Can you pls explain me to understand this. I got same kind of requirement from my client i want to deliver this by Monday. Can you pls help me here. Also i have posted a query in my page on this.
Also I downloaded testselectfromstring.qvw. Got the information from there. But I am using MDX query for this app. Pls find the script below and explain me how I want write the script in dimension and expression, i mean conditional script
CONNECT32 TO [Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=False;Data Source=localhost];
[Measures].[USD - Final Budget],
[Measures].[USD - Final Actuals]
DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS , NON EMPTY
TAG FIELDS [Account LKP] , $Dimension;
TAG FIELDS [Activity LKP] , $Dimension;
LOAD * INLINE [_dimension
These are the script i wrote in Edit script.
=SubStringCount(Concat(_dimension, '|'), '"[Measures].[USD - Final Budget]"') I used in conditional expression
SubStringCount(Concat(_dimension,'|'), '"[Account LKP].[Lookupid].[Lookupid].[MEMBER_CAPTION]"') I used in Enable conditional dimension
Pls help me here.
Test -1.qvw 349.8 K