topic Re: Choose which Column to use in QlikView

Choose which Column to use

dhborchardt — Tue, 27 May 2014 21:08:54 GMT

I have an application that looks at different service areas indicated by zip codes. I can click on P and view only the zip codes that are in the primary service area, S and get secondary etc. I now need to be able to look at a second hospital which has different primary/secondary service areas. If I need to analyse Hospital 1, I will use the first column or (Hospital 1) to determine primary, secondary etc.. If I need to analyse hospital 2 I will use the second column or (Hospital 2). The application has four tabs and I hate to just recreate all four tabs. Is there a way to use a toggle button to select the column that gets used or is there some way I am not thinking of. I have included a very simplified example of the data below.

Re: Choose which Column to use

MarcoWedel — Tue, 27 May 2014 22:06:04 GMT

Hi Dale,

you could try a crosstable load of your data.

This should give multiple possibilities to display and select your data as descibed:

table1:
CrossTable(Hospital ,ServiceArea, 1)
LOAD [Zip Code], Hospital1, Hospital2
INLINE [
    Hospital1, Hospital2, Zip Code
    P, N, 57834
    S, S, 57921
    P, S, 57333
    N, P, 57612
    S, S, 57002
];

hope this helps

regards

Marco

Re: Choose which Column to use

dhborchardt — Fri, 30 May 2014 12:32:09 GMT

Thank you. That did the job.