Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

sibin_jacob
Contributor III

Straight table data not filtering

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

5 Replies
sujeetsingh
Honored Contributor III

Re: Straight table data not filtering

Why dont you paste a sample..

sibin_jacob
Contributor III

Re: Straight table data not filtering

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.

sujeetsingh
Honored Contributor III

Re: Straight table data not filtering

Hi ,

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

sujeetsingh
Honored Contributor III

Re: Straight table data not filtering

See the attached file it is workin fine..

sibin_jacob
Contributor III

Re: Straight table data not filtering

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

Community Browser