topic Re: Show/hide rows in table based on selection in QlikView

Show/hide rows in table based on selection

Anonymous — Fri, 10 Oct 2014 06:43:03 GMT

Hi community,

I need to show in a table some rows based on the current selection. I mean, at the same way I obtain the result in a text box of this experession:

count({1<CanaldeVentaId=p(TecnicoId), InicioContratoEjercicioMes=p([FInicio EjercicioMes]), TipoRelacion={'R'}>} DISTINCT Contrato)

now I need to show these 'Contratos' involved in the set analysis selection.

I tried with a calculated dimension:

=aggr({1<CanaldeVentaId=$::TecnicoId, InicioContratoEjercicioMes=$::[FInicio EjercicioMes], TipoRelacion={'R'}>} Contrato, Contrato)

but it doesn't work .

Any help?

Thanks in advance.

Marc.

Re: Show/hide rows in table based on selection

phaneendra_kunc — Fri, 10 Oct 2014 06:52:26 GMT

What happened when you add below expression with "Contractos" as dimension.

count({1<CanaldeVentaId=p(TecnicoId), InicioContratoEjercicioMes=p([FInicio EjercicioMes]), TipoRelacion={'R'}>} DISTINCT Contrato)

Re: Show/hide rows in table based on selection

Anonymous — Fri, 10 Oct 2014 06:57:55 GMT

Thanks Phaneendra for reply,

I obtain a huge list of Contratos with a 1 in each row. For the selection I use now, I expect only 4 rows.

Any idea?

Re: Show/hide rows in table based on selection

phaneendra_kunc — Fri, 10 Oct 2014 06:59:26 GMT

Is it possible to share your qvw? and how many u see in the count expression

Re: Show/hide rows in table based on selection

Fri, 10 Oct 2014 07:08:20 GMT

Use Contrato as dimension

and expression like:

=only(aggr({1<CanaldeVentaId=$::TecnicoId, InicioContratoEjercicioMes=$::[FInicio EjercicioMes], TipoRelacion={'R'}>} Contrato, Contrato))

Re: Re: Show/hide rows in table based on selection

Anonymous — Fri, 10 Oct 2014 07:30:21 GMT

Se attached.

Testing with selection TecnicoId=20724, in the left side you have the output table, and in the right side you have the expected output (running in an alternate state).

Thanks.

Marc.

Re: Re: Show/hide rows in table based on selection

Anonymous — Fri, 10 Oct 2014 07:30:50 GMT

Angad, it gives me a dimension error...

Re: Show/hide rows in table based on selection

Fri, 10 Oct 2014 07:50:14 GMT

You must use Contrato as dimension

and expression like:

=only(aggr({1<CanaldeVentaId=$::TecnicoId, InicioContratoEjercicioMes=$::[FInicio EjercicioMes], TipoRelacion={'R'}>} Contrato, Contrato))

Re: Show/hide rows in table based on selection

Fri, 10 Oct 2014 08:01:02 GMT

Use Contrato as dimension

and expression as

count({1<CanaldeVentaId=p(TecnicoId), TipoRelacion={'R'}>} DISTINCT Contrato)

Thanks,

Singh

Re: Re: Show/hide rows in table based on selection

Anonymous — Fri, 10 Oct 2014 10:56:16 GMT

Phaneendra Kunche and Angad Singh,

I was too fast in my answer. There's still something wrong. I re-attach the sample with the modified expression and the state well linked in the table Result.

Please tell me.

Thanks!

Re: Show/hide rows in table based on selection

Fri, 10 Oct 2014 11:31:39 GMT

Use below in expression for Result Table:

=only({1<CanaldeVentaId=$::TecnicoId, TipoRelacion={'R'}>}Contrato)

The main issue is with below statement, both of these columns are not have similar values.

For this case

InicioContratoEjercicioMes : example: jun 2014

FInicio EjercicioMes: (state-ToDo) : example: 07-2014

InicioContratoEjercicioMes=$::[FInicio EjercicioMes]

You need to make them into same format to match and then use it in expression.

Hope this was helpful.

Thanks,

Singh

Re: Re: Show/hide rows in table based on selection

Anonymous — Fri, 10 Oct 2014 12:15:39 GMT

Singh,

I understand you mean that the trouble is with this month fields' format. I loaded now InicioContratoEjercicioMes as 'MM-YYYY' but it isn't working yet.

I re-attach with modifications.

Thanks Singh.

Re: Re: Re: Show/hide rows in table based on selection

Fri, 10 Oct 2014 12:49:59 GMT

But if I select the other 2 fields then I can see the value. Can you please check attached.?

Thanks,

Singh

Re: Re: Show/hide rows in table based on selection

Anonymous — Fri, 10 Oct 2014 13:19:09 GMT

Singh,

I created ToDo state just to see the expected result. If you select values in a list linked to this state, of course it is working well. Let's say I created the objects in the rifgt side just to check if the value in result is exactly the expected. The list objects you created are in ToDo state...

The idea is the user will not be able to make selections in InicioContratoEjercicioMes. So, that is why I'm giving the possibles values from [FInicio EjercicioMes] to InicioContratoEjercicioMes. This, cobined with selection in TecnicoID, will give me the list of Contratos involved in.

For instance, if i have

Contrato TecnicoId CanaldeventaId

A 20724 1234

B 20724 5678

C 9876 20724

omitting the month fields, if the user select TecnicoId=20724, i want the table to show the Contrato C, because is the only one where CanaldeVentaId equals TecnicoId.

Any idea?

And thanks again for helping.

Re: Re: Re: Show/hide rows in table based on selection

Fri, 10 Oct 2014 15:14:53 GMT

Your scenario will work if you use P() function, which is just like wildmatch search of possible values.

But the case is when you use Alternate State, it is not actually checking possible values, but the selected value(single value) (as per my understanding)

And for each [FInicio EjercicioMes] we have multiple InicioContratoEjercicioMes, so may be that is why it is not working.

It will great, if you create a new thread, with particular this scenario, so that rest of the members might also help.

Happy to Help

Singh

Re: Re: Show/hide rows in table based on selection

Anonymous — Fri, 10 Oct 2014 15:23:06 GMT

Thank you Singh. I prepare a better sample and I start a new thread.

Marc.