Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Straight Table

Hi All,

I have a straight table and have 10 dimensions and 2 expressions.

Now whenever i select any dimension in the straight table chart it will filter and i when ever i select the filtered one it will un-filter.

My requirement is, is there anyway to highlight(with colour) the selected field or dimension in straight table so that i can know which dimension got filtered in case if i forget what is filtered. So that i can un-filter.

Please let me know if we can achieve this.

Thanks,

Bharat

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Straight Table

Hi Bharat,

if(GetSelectedCount(FieldName) >0, Red()

)

I think, you need to write for each filed/dimension.

View solution in original post

9 Replies
Highlighted
Partner
Partner

Re: Straight Table

Hi Bharat

once a field is selected you can check it thru current selection menu or current selection object if you set one

but I would say a straight table would may not be the best way to show too many information

think to a pivot table instead or think about cycle/hierarchical groups and even best would be to keep only useful dimension

enjoy  it

juju

Highlighted
Creator III
Creator III

Re: Straight Table

Thanks Christian. But my requirement is with straight table it-self.. I just want to know is there any way can we achieve this..

Highlighted
Creator II
Creator II

Re: Straight Table

can you be specific please?

Highlighted

Re: Straight Table

The field that is being filtered will show a green dot (beacon) in the column header.

Highlighted
Creator III
Creator III

Re: Straight Table

I have a straight table where the image is

straight table.PNG:

Now when i select 2 in day of year it will filter as below image:

ST.PNG

Is there any way to highlight the background with colour for example say  that now i filtered  day of year dimension so it should highlight with some colour.

N when i un-filter the colour should be .normal.

Please let me know if you require anything more.

Thanks,

Bharat

Highlighted
Creator III
Creator III

Re: Straight Table

Hi Bharat,

if(GetSelectedCount(FieldName) >0, Red()

)

I think, you need to write for each filed/dimension.

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Straight Table

Hi Bharat,

You can also try to write in each dimension background color expression (Click + near the dimension name)

=If( GetCurrenField() = [Dimension/Field name], Blue())

You can also use Prashanth expression.

Highlighted
Creator III
Creator III

Re: Straight Table

Thanks Prashanth...

Highlighted
Creator III
Creator III

Re: Straight Table

Thanks Uri