topic Conditional Straight Table Dimension in QlikView

Conditional Straight Table Dimension

Mon, 06 Feb 2012 11:09:04 GMT

I want to display dimensions in my straight table only if a selection was made for that dimension.

I'm not really sure if I can use GetCurrentSelection() for this.

I've tried using GetCurrentSelection() in a text object to see what it returns and it returns something like this:

Product: Potatoes

Size: Large

Would i be able to search that string for the dimensions name? and if i can how would i do that?

Conditional Straight Table Dimension

kaushiknsolanki — Mon, 06 Feb 2012 11:11:39 GMT

Hi,

Use the system field i.e $Field.

This field will give you full list of field names.

Then you can use just =$Field in textbox to get the selected field name.

Regards,

Kaushik Solanki

Conditional Straight Table Dimension

Mon, 06 Feb 2012 11:28:58 GMT

I've done the following in the conditional show of the specific dimension/column:

GetCurrentSelection() Like '*Product*'

This show/hide the column, but the data in the straight table doesn't get effected.

What i'm trying to achieve is to get qlikview to group the data if that dimension is not visible, basically the same effect if i had to remove the dimension?

Conditional Straight Table Dimension

kaushiknsolanki — Mon, 06 Feb 2012 11:34:06 GMT

Hi,

Have a look at the application i had attached in below post.

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

This will solve your problem.

Regards,

Kaushik Solanki

Conditional Straight Table Dimension

jagan — Mon, 06 Feb 2012 12:23:46 GMT

Hi,

Try using Calculated dimension

=If(GetSelectedCount(Product) > 0, Product, DefaultDimensionName )

The above Calculated Dimension expression checks whether any Product has been selected, if yes then Product is used as dimension otherwise uses the Default Dimension.

Hope this helps you.

Regards,

Jagan.

Conditional Straight Table Dimension

Mon, 06 Feb 2012 12:41:19 GMT

@ Kaushik,

I couldn't open the app cuz i'm still using the personal edition but i did however managed to figure it out.

@ Jagan

This is the way i went. However I ended up doing this in the calculated dimension:

=if(GetCurrentSelection() Like '*Product*', Product)

Then I just added : GetCurrentSelection() Like '*Product*' in the conditional show for that dimension.

So when the calculated condition returns null if a Product is not selected, then the column doesn't show and it groups the rest of the data together cuz all the data will have a Null value for the Product field.

Thanks for the help to both of you though.