Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Default Straight Table with Add Dimensions feature

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,

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

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,

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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?


talk is cheap, supply exceeds demand
Highlighted
Creator II
Creator II

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.

Highlighted
Creator II
Creator II

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,

View solution in original post