topic Default Straight Table with Add Dimensions feature in QlikView

Default Straight Table with Add Dimensions feature

gaurav2017 — Thu, 06 Dec 2012 06:33:53 GMT

Hi,

I need to show some default fields in a straight table, & then the feature of adding fields in that table. Is it possible, if it is then can you help me. I used the similar logic implemented in "What's New in QlikView 11" example document.

Regards,

Re: Default Straight Table with Add Dimensions feature

Gysbert_Wassenaar — Thu, 06 Dec 2012 09:05:11 GMT

Look at the expressions in the Enable Conditional text boxes for the dimensions in the table.

For example =SubStringCount(Concat(_dimension, '|'), 'Region')

What happens is that there's a table with the dimension fields you can select in. The concat function creates a string that contains all the selected fields. Substringcount then checks if 'Region' is in that string. If it is then the complete expression returns 1 (=True, so show), otherwise 0 (=False, so hide). Does that help?

Re: Default Straight Table with Add Dimensions feature

gaurav2017 — Fri, 07 Dec 2012 04:53:05 GMT

I used this expression for some of the fields in a straight table which are to be appeared in "Additional Fields" List Box & rest which should appear by default, for that I checked on "Always" appear option.

Also, I put the expression on straight table Properties --> general tab

Conditional ---> "=GetSelectedCount(_Dimension) >:0"

but it doesn't help.

Re: Default Straight Table with Add Dimensions feature

gaurav2017 — Thu, 13 Dec 2012 14:32:13 GMT

I tagged all the fields & created a button to call a bookmark "select the default values" & now it's working fine. Thanks frnd 4 help.

Regards,