topic Re: Straight Table in QlikView

Straight Table

bharatkishore — Thu, 10 Aug 2017 13:01:47 GMT

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

Re: Straight Table

jujucts — Thu, 10 Aug 2017 13:06:36 GMT

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

Re: Straight Table

bharatkishore — Thu, 10 Aug 2017 13:11:15 GMT

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

Re: Straight Table

oseimuduame — Thu, 10 Aug 2017 13:14:46 GMT

can you be specific please?

Re: Straight Table

Colin-Albert — Thu, 10 Aug 2017 13:24:11 GMT

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

Re: Straight Table

bharatkishore — Thu, 10 Aug 2017 13:27:52 GMT

I have a straight table where the image is

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

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

Re: Straight Table

d_prashanthredd — Thu, 10 Aug 2017 14:01:20 GMT

Hi Bharat,

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

)

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

Re: Straight Table

sonkumamon — Thu, 10 Aug 2017 14:11:28 GMT

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.

Re: Straight Table

bharatkishore — Thu, 10 Aug 2017 14:19:09 GMT

Thanks Prashanth...

Re: Straight Table

bharatkishore — Thu, 10 Aug 2017 14:19:31 GMT

Thanks Uri