Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sibin_jacob
Creator III
Creator 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
Master III
Master III

Why dont you paste a sample..

sibin_jacob
Creator III
Creator III
Author

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
Master III
Master III

Hi ,

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

sujeetsingh
Master III
Master III

See the attached file it is workin fine..

sibin_jacob
Creator III
Creator III
Author

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