Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Selections on Charts

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

1 Solution

Accepted Solutions
sunny_talwar

Can you try changing your expression to:

Count([Billing Document])

or

GetSelectedCount([Billing Document]) >= 1

View solution in original post

10 Replies
Chanty4u
MVP
MVP

give get selected count to  2  or 1

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

sunny_talwar

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

Anonymous
Not applicable

Plz share the screen shot and sample data.

bharatkishore
Creator III
Creator III
Author

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:

Doc.PNG

Document No is displayed in second straight table chart

Doc1.PNG

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

Doc2.PNG

Nothing is displayed in second straight table chart

Doc3.PNG

Expression i have written is

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

bharatkishore
Creator III
Creator III
Author

I have shared sandip..

bharatkishore
Creator III
Creator III
Author

I tried Chanty it is not working..

sunny_talwar

Is there a dimension or just an expression?

bharatkishore
Creator III
Creator III
Author

It is calculated Dimension.

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

And expression is

GetSelectedCount([Billing Document]) = 1

sunny_talwar

Can you try changing your expression to:

Count([Billing Document])

or

GetSelectedCount([Billing Document]) >= 1