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: 
Not applicable

Unable to select a row in Straight Table

I have a straight table chart, in which I am using a complicated expression to show the dimension.

The problem is that when I click on a row, the same is not selected, while it should be.

I am attaching an example to demo this issue. I think it is a bug. Thank you for any inputs.

Regards,
Sagar

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi Sagar,

PFA file for solution.

Regards,

Jagan.

View solution in original post

13 Replies
sudeepkm
Specialist III
Specialist III

Can you pls paste your Calculated Dimension here? Mine is a personal edition and not able to open your file.

jagan
Luminary Alumni
Luminary Alumni

Hi Sagar,

Please find attached file for solution.

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Restricted the display in Chart Properties -> Presentation -> Max Number (1-100) section

Removed the calculated dimension.

Regards,

Jagan.

Not applicable
Author

Jagan,

I know it works without the calculated dimension but the purpose is to make this work with a calculated dimension. That is the functionality of the dashboard. 🙂

I had kept a simple calculation with 'If condition', only to put my question across. I have a lengthier calculated dimension in my dashboard that I cannot get rid of. This looks like a bug.

Any other thing that comes to you mind?

Thanks,

Sagar

Not applicable
Author

Sudeep,

You should be able to open this now. Its not a personal edition file.

If you still arent, I have a calculated expression that goes like

if(fieldA='ABC', fieldB,fieldC)

jagan
Luminary Alumni
Luminary Alumni

Hi Sagar,

PFA file for solution.

Regards,

Jagan.

tresesco
MVP
MVP

Sagar,

Tha is not a bug. The behavior is natural for your data. if you remove 'Always One Selected Value' from radiobutton field, it would work. If you keep one value selected and try to select a single value from Customer, that would not work because for any selection in radiobutton all possible combination of customers are associated. So the scope of selection is contradictory there.

Hope this gives you an idea.

Not applicable
Author

Thank you Jagan. This works brilliantly. Adding an Aggr() in the start of the calculated dimension solved it.

Do you think it might cause any performance concerns?

Not applicable
Author

Thank you Tresesco. That made complete sense. And it started working for me when I unchecked the 'Always One Selected Value' option. But I wonder, how is Jagan's solution above (which I have marked correct) working just fine?

Any thoughts would be helpful.

Regards