topic Re: Selections on Charts in QlikView

Selections on Charts

bharatkishore — Wed, 16 Mar 2016 10:09:39 GMT

Hi All,

I have two straight table charts. Now in second straight table chart i have given condition as

='Billing Document Details(' & IF(GetSelectedCount([Billing Document])=0, 'No Doc Selected', [Billing Document]) & ')'

Now in the 1st straight table if i click one document number below chart will be displayed.

Now my requirement is if i click on multiple document numbers in the first straight table chart down the same number of selected document numbers should be displayed.

Currently it is working if i select only 1 document number, not working when i select multiple document numbers.

Can you please tell me how to do this.

Thanks,

Bharat

Re: Selections on Charts

Chanty4u — Wed, 16 Mar 2016 10:11:56 GMT

give get selected count to 2 or 1

etSelectedCount([Billing Document])=2, 'No

Re: Selections on Charts

sunny_talwar — Wed, 16 Mar 2016 10:12:23 GMT

Do you have a sample you can share? Its difficult to understand what you are trying to achieve?

Re: Selections on Charts

Anonymous — Wed, 16 Mar 2016 10:17:33 GMT

Plz share the screen shot and sample data.

Re: Selections on Charts

bharatkishore — Wed, 16 Mar 2016 10:20:56 GMT

Hi Sunny,

Sorry i cannot share the qvw but better understanding i will attach images:

If i select single document in 1st straight table chart:

Document No is displayed in second straight table chart

If i select multiple numbers in 1st straight table chart:

Nothing is displayed in second straight table chart

Expression i have written is

='Billing Document Details(' & IF(GetSelectedCount([Billing Document])=0, 'No Doc Selected', [Billing Document]) & ')'

Re: Selections on Charts

bharatkishore — Wed, 16 Mar 2016 10:21:19 GMT

I have shared sandip..

Re: Selections on Charts

bharatkishore — Wed, 16 Mar 2016 10:22:47 GMT

I tried Chanty it is not working..

Re: Selections on Charts

sunny_talwar — Wed, 16 Mar 2016 10:27:17 GMT

Is there a dimension or just an expression?

Re: Selections on Charts

bharatkishore — Wed, 16 Mar 2016 10:30:14 GMT

It is calculated Dimension.

='Billing Document Details(' & IF(GetSelectedCount([Billing Document])=0, 'No Doc Selected', [Billing Document]) & ')'

And expression is

GetSelectedCount([Billing Document]) = 1

Re: Selections on Charts

sunny_talwar — Wed, 16 Mar 2016 10:32:38 GMT

Can you try changing your expression to:

Count([Billing Document])

GetSelectedCount([Billing Document]) >= 1

Re: Selections on Charts

bharatkishore — Wed, 16 Mar 2016 10:34:47 GMT

Thanks Sunny..