Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
MVP & Luminary
MVP & Luminary

Re: Re: Re: Unable to select a row in Straight Table

Hi Sagar,

PFA file for solution.

Regards,

Jagan.

View solution in original post

13 Replies
sudeepkm
Valued Contributor III

Re: Unable to select a row in Straight Table

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

MVP & Luminary
MVP & Luminary

Re: Unable to select a row in Straight Table

Hi Sagar,

Please find attached file for solution.

Regards,

Jagan.

MVP & Luminary
MVP & Luminary

Re: Unable to select a row in Straight Table

Hi,

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

Removed the calculated dimension.

Regards,

Jagan.

Not applicable

Re: Unable to select a row in Straight Table

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

Re: Re: Unable to select a row in Straight Table

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)

MVP & Luminary
MVP & Luminary

Re: Re: Re: Unable to select a row in Straight Table

Hi Sagar,

PFA file for solution.

Regards,

Jagan.

View solution in original post

MVP
MVP

Re: Unable to select a row in Straight Table

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

Re: Re: Re: Unable to select a row in Straight Table

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

Re: Re: Re: Unable to select a row in Straight Table

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