Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'll include two screenshots. The first is the filtered data showing null values, the second the unfiltered, showing the script loaded values. I'll also past a third that shows the inuput script for Catflag and Attflag. I see no reason why loaded constants should change because of a data filtration change... My dimension is WCAT, another loaded input.
If your inline tables are associated with the other table(s) in the data model then selecting values in a field from the fact
table will filter the data from inline tables too. I assume this is what happens. Take a look at the Table Viewer to check your data model.
Your screenshot is too small to make out any details. Not that it matters because screenshots are usually useless anyway.
If you need more help please post a small qlikview document that demonstrates the problem. See this document for more information about that: Preparing examples for Upload - Reduction and Data Scrambling
Hi Patrick Lee
Just gentle advise, Please use appropriate subject instead of debrief the issue.
Can you please attach the sample file to demonstrate the issue? Thank you.