topic Re: Numbers selection not giving value in a table in QlikView

Numbers selection not giving value in a table

ferha_jafri — Sat, 06 Oct 2018 02:37:50 GMT

Hello Experts,

I have a requirement in which I want a particular format given by user, the problem is that the requirement of the pivot table is completed through Data Island table but user wants when they select the number in pivot all data corresponding to that value should be selected.

PFA with the sample application in the application if you select on 1 in the pivot table then 1 ID should be selected in ID column.

Thanks in advance

Ferha

Re: Numbers selection not giving value in a table

petter — Sat, 06 Oct 2018 09:29:06 GMT

I think you should avoid using data islands.

Re: Numbers selection not giving value in a table

ferha_jafri — Sat, 06 Oct 2018 15:15:30 GMT

What would you suggest in the case as user want total and % calculation and there corresponding calculations ,how to handle the requirement.

Re: Numbers selection not giving value in a table

captain89 — Sun, 07 Oct 2018 11:39:54 GMT

I don't really understand why you don't join tables.

If you do it you can make a button with select possible values in id fields.

When you say "when they select the number in pivot " what does it mean?

When you select priority ='Y' you push the button and all IDs will be selected.