Dimension (Enable Conditional)

[#1]

Hi Guys,

I have just move from QV10 to QV11 and interest in using the "Enable Conditional" feature of the QV11.

Hope you can help me implement the my requirement.

I created a sample reporty with the following fields:

BOOKID

TITLE

AUTHOR

COUNTRY

PAGES

QUANTITY

What I wanted to do is to initially provide the BOOKID as the only dimension, is it possible that when the user opens the report they will only see something like:

BOOKID     |  QUANTITY

Then if they do want additional dimension they can just click on a list or drag and drop (not so sure how)?

Normally different user requires different arrangement on the DIMENSIONS. Is it possible to have a drag and drop dimension by the way?

Pleas see sample QVW hope you can help me.

Thanks

~skip

[Alexander_Thor]

Instead of going into a leangthy explenation check out the What's new in QV11 app under the reports tab.

Sounds exactly what you are looking for. Download the qvw and check out the how it's built.

http://eu.demo.qlik.com/detail.aspx?appName=Whats%20New%20in%20QlikView11.qvw

[#3]

Hi ~skip,

Please refer to the below thread and it shows how in three different ways you can implement your requirement. I believe it is much easier and cleaner to implement using the macro option

http://community.qlik.com/message/41994#41994

Hope it helps

Cheers,

Ravi

[#4 · Accepted solution]

Please find an example of what you can do with conditional expression.

[#5]

Hi Hans,

Thanks very much, not exactly what I need but very helpful.

The arrangement seems static... doesn't matter which one you select first.

Thanks for your help.

Regards,

~skip

[#6]

Hi ,

I am using the same method as Hans'

- adding dimensions to a straight table by conditionally enabling (in the Dimensions Tab of the Straight Table Properties Box) them according to selection in a list box with values that come from a disconnected table. I use the same formula as Hans' -

=GetSelectedCount(_DIMENSION)>0 and SubStringCount( GetFieldSelections(_DIMENSION), 'PartID')>=1

The dimension values table is a small data island in the model and it has title _Dimension to hide it from the current selection box

Now, it works fine, but every now and then I get Allocated Memory Exceeded message in my straight table. When I click some dimension value and unclick others and do this several times it starts working until the next such message.

Does anyone know the cause of this? The issue is not the size of data - my data table is not that big and the message appears even for selections that reduce the data set to few lines.

[#7]

This is really annoying, it works fine and when I press the Clear Button and my straight table has to reduce back to the 2 main (non-conditional) dimensions, the message appears Allocated Memory Exceeded and stays for quite many clickings afterwards until it starts working again. Anyone had the same problem? How to fix it?

[#8]

I'm having the same problem - its not a data volume issue; it appears to be a query complexity issue.  I'm looking for workarounds or ways to make the formulas simpler.  Any ideas?

[#9]

I'm having the same problem - its not a data volume issue; it appears to be a query complexity issue.  I'm looking for workarounds or ways to make the formulas simpler.  Any ideas?

[#10]

I'm having the same problem - its not a data volume issue; it appears to be a query complexity issue.  I'm looking for workarounds or ways to make the formulas simpler.  Any ideas?