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

Unable to select a row in Straight Table

Mon, 21 Oct 2013 08:12:32 GMT

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

Re: Unable to select a row in Straight Table

sudeepkm — Mon, 21 Oct 2013 08:22:06 GMT

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

Re: Unable to select a row in Straight Table

jagan — Mon, 21 Oct 2013 08:31:51 GMT

Hi Sagar,

Please find attached file for solution.

Regards,

Jagan.

Re: Unable to select a row in Straight Table

jagan — Mon, 21 Oct 2013 08:34:31 GMT

Hi,

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

Removed the calculated dimension.

Regards,

Jagan.

Re: Unable to select a row in Straight Table

Mon, 21 Oct 2013 08:48:47 GMT

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

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

Mon, 21 Oct 2013 08:52:51 GMT

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)

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

jagan — Mon, 21 Oct 2013 09:00:15 GMT

Hi Sagar,

PFA file for solution.

Regards,

Jagan.

Re: Unable to select a row in Straight Table

tresB — Mon, 21 Oct 2013 09:07:14 GMT

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.

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

Mon, 21 Oct 2013 09:08:48 GMT

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?

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

Mon, 21 Oct 2013 09:13:04 GMT

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

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

jagan — Mon, 21 Oct 2013 09:27:25 GMT

Hi,

Aggr() will loop through all the values in the Customer, and then your if() is evaluated against each Customer. Aggr() will have performance issue if the data is huge, for small data it is not a problem.

Regards,

Jagan.

Re: Unable to select a row in Straight Table

tresB — Mon, 21 Oct 2013 09:33:31 GMT

That is what I was trying to say. See, if you use the expression : if(radiobutton='All',Customer,Customer) as calculated dimension then, for radiobutton value 'All' all customer values are possible and displayed and similarly for 'Top3' all values (A, B, C, D, E, F) are possible. If you try to select one of them, the scope of the radiobutton field is expanded to both 'Top3' and 'All', but that is restricted by Always One Selected Value, so can't get selected both the values. And again the values of the calculated dimension is dependent on the radiobutton field so it gets calculated back to all possible values (kind of circular reference; so it can't reduce the data based on calculated field selection).

And how Jagan's solution work:

There the dimension is not calculated and doesn't depend on radiobutton values, hence there is no such circular reference unlike calculated field.

Re: Unable to select a row in Straight Table

Mon, 21 Oct 2013 09:37:42 GMT

Thanks Tresesco, I understood the circular reference part. You are looking at incorrect file that Jagan has uploaded. Jagan's correct solution has a calculated dimension and also the 'Always one selected value' is checked and still row selection is working correctly, which is surprising.

Re: Unable to select a row in Straight Table

tresB — Mon, 21 Oct 2013 09:47:49 GMT

No, , even that is not surprising ! Jagan'solution is a clever one ! The values of customer are being taken after aggregating using "=Aggr(If(Only(radiobutton) = 'All', Customer, if(Rank(Sum(Sales)) < 4, Customer)), Customer)" . With this, the generated customers are not like your earlier data. If you select 'Top3' here, you don't see all of the customers, rather restricted to top three values.

Hope this clarifies.