topic Re: single column in QlikView

single column

soniasweety — Sat, 16 Nov 2024 20:46:31 GMT

Hi all tresesco

, Vegar

i have a region field like

TableA:

Region

Region2

Region3

Region4

Product

amount

concatenate

Region

Region2

Region3

Region4

..... like that i have because in front end i have 4 seperate tabs each tab im using seperate region field

so now user told i need one region filed if we select one region value now it should reflect all 4 tabs..

so how can i make single region field here?

Re: single column

jaibau1993 — Wed, 29 May 2019 06:34:09 GMT

Hi!

If I have understood your problem then I think that you should have all regions in one column. You can do it using CrossTable. Try something like

CrossTable (RegionType, Region, 2) LOAD Product, amount, Region, Region2, Region3, Region4 From Wherever;

The output is the following:

But this may force you to modify expressions in front-end. For example, Count(Region4) now must be written Count( {<RegionType = {'Region4'}>} Region)

Regards,

Jaime

Re: single column

soniasweety — Wed, 29 May 2019 07:15:28 GMT

No. i want a global filter .. not into the expressions 😞

Re: single column

soniasweety — Wed, 29 May 2019 07:46:40 GMT

i want to link the filters across 4 tabs.

so by that user can select one value in one filter entire dashboard will be reflected.

Re: single column

jaibau1993 — Thu, 30 May 2019 11:47:54 GMT

Try using Field Triggers (Document Properties >> Triggers) and try to copy selections from one region to the others "on select"

Jaime