topic Re: Dimension (Enable Conditional) in QlikView

Dimension (Enable Conditional)

Fri, 17 Aug 2012 08:23:33 GMT

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

Re: Dimension (Enable Conditional)

Alexander_Thor — Fri, 17 Aug 2012 08:33:13 GMT

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

Re: Dimension (Enable Conditional)

Fri, 17 Aug 2012 08:36:47 GMT

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

Re: Dimension (Enable Conditional)

Fri, 17 Aug 2012 08:54:23 GMT

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

Re: Dimension (Enable Conditional)

Fri, 17 Aug 2012 09:26:44 GMT

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

Re: Dimension (Enable Conditional)

Tue, 21 Aug 2012 09:50:08 GMT

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.

Re: Dimension (Enable Conditional)

Thu, 23 Aug 2012 13:39:18 GMT

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?

Re: Dimension (Enable Conditional)

Tue, 25 Sep 2012 18:39:49 GMT

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?

Re: Dimension (Enable Conditional)

Tue, 25 Sep 2012 18:39:54 GMT

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?

Re: Dimension (Enable Conditional)

Tue, 25 Sep 2012 18:40:10 GMT

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?

Re: Dimension (Enable Conditional)

Fri, 15 Mar 2013 11:04:42 GMT

Hello,

could you please give me any advice about my problem? Maybe you already met this.

I have dimensions in listbox which are similar. That mean that some of them contains same words.

Customer

Customer Phone

Customer Country

When "Customer phone" is selected, in table "Customer" will appear as well. Is there any chance to use theese similar names in list box with dimensions? Now is this conditional expression in use:

=SubStringCount(Concat(Fields, '|'), 'Customer')

Thank you!

Re: Dimension (Enable Conditional)

jyothish8807 — Mon, 01 Jun 2015 13:24:52 GMT

Even i have the same issue. Did you get any solution for this?

Regards