topic Re: Straight table data not filtering in QlikView

Straight table data not filtering

sibin_jacob — Tue, 18 Dec 2012 06:54:25 GMT

Hi,

I have two straight table. One is for physician level data another one is for ZIP level data.

In backend my data is in Physician level. I am rolling the physician level data to show the ZIp level.

When I am selecting a physician, my zip level table is not get filtered . its showing all the zips.

In ZIp level table my dimension is ZIP and expression is

sum ({$<Product_ID={1},Physician_Name=>} Volume)

I need Filtered Zip in Zip level table.

Thanks,

Sibin Jacob

Re: Straight table data not filtering

sujeetsingh — Tue, 18 Dec 2012 07:05:33 GMT

Why dont you paste a sample..

Re: Straight table data not filtering

sibin_jacob — Tue, 18 Dec 2012 09:12:27 GMT

Hi,

Here I attached my sample application. I need Zip level volume in Zip level table and physician level volume in physician level table.

When I am selecing a physician I need to filter zip level table based on physician. If I am selecing one physician from ZIP1 , In Zip level table I need to show only Zip1 and the volume 50.

Thanks,

Sibin Jacob.

Re: Straight table data not filtering

sujeetsingh — Tue, 18 Dec 2012 09:31:29 GMT

Hi ,

I dont get that why are you using set analysis..

Re: Straight table data not filtering

sujeetsingh — Tue, 18 Dec 2012 09:32:42 GMT

See the attached file it is workin fine..

Re: Straight table data not filtering

sibin_jacob — Tue, 18 Dec 2012 11:17:04 GMT

Hi,

In this attached file Zip filter is working fine. But I am not getting exact value in zip level. Using set analysis I am getting the exact value in Zip level.

Zip1 value is 50.

Based on physician selection my Zip value is changing. I don't want to change Zip level value. But I need to filter the zip.

Thanks,

Sibin Jacob