topic Selection related Query in QlikView

Selection related Query

Wed, 22 Jul 2015 06:25:08 GMT

Dear Team,

i am using a report which contain table Information and below that Conditional Graph Report.

The table show me scrip Name wise report as below :

When i select a particular Scrip from above its shows me graph as below :

My requirement is when i select a particular Scrip Name from above table i want table state( list of Scrips and there orders) should not change to 1 record only. i also that selected Scrip row get highlighted.. when i select it.

Kindly let me know is this possible and if yes how can i achieve this.

if anyone required sample data i can also provide some dummy data for same.

Re: Selection related Query

lironbaram — Wed, 22 Jul 2015 06:28:56 GMT

yes you can do it , by using set analysis

if you can provide demo data,

i'll build an example.

but from business point of view i don't see why it's better then how qlikview works

Re: Selection related Query

abhaysingh — Wed, 22 Jul 2015 06:52:10 GMT

hi,

you can bypass the field from expression. and it will not change into one record.

hopw it helps

Re: Selection related Query

pokassov — Wed, 22 Jul 2015 06:55:18 GMT

Hello!

Q1:

Add to your expressions set_analysis like that:

sum({$<Scrip=>} Grip)

Q2:

Add Variable fScrip: =Scrip

Chart -> Dimensions -> ->Text Format

=if(Scrip=fScrip,'<B>')

Use the same way for expressions.

Re: Selection related Query

Wed, 22 Jul 2015 07:12:32 GMT

Hi,

Thanks i will try it and let you know if i required any help

Re: Selection related Query

Wed, 22 Jul 2015 07:13:41 GMT

Hi,

Thanks i will try it and let you know if i required any help, in you suggestion that will help but i have to right in each cells Expression if i required to show the computed value also.