Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you try changing your expression to:
Count([Billing Document])
or
GetSelectedCount([Billing Document]) >= 1
give get selected count to 2 or 1
etSelectedCount([Billing Document])=2, 'No
Do you have a sample you can share? Its difficult to understand what you are trying to achieve?
Plz share the screen shot and sample data.
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]) & ')'
I have shared sandip..
I tried Chanty it is not working..
Is there a dimension or just an expression?
It is calculated Dimension.
='Billing Document Details(' & IF(GetSelectedCount([Billing Document])=0, 'No Doc Selected', [Billing Document]) & ')'
And expression is
GetSelectedCount([Billing Document]) = 1
Can you try changing your expression to:
Count([Billing Document])
or
GetSelectedCount([Billing Document]) >= 1