Discussion board where members can get started with Qlik Sense.
I don't want to include the dimension "Z" in my bar chart. How do I exclude this?
Go to Solution.
Couple of options I can think of. The first would be to create a calculated dimension in place of your normal dimension that looks like:
The other, more friendly option would be to write the same as a separate field in your load script.
Thanks for the response. That didn't exactly work however. I should have added that this is part or a drill-down. Does that have an impact?
Yes, if you have a drill down group you would want to edit this dimension in the group settings. If I'm not understanding this correctly would you mind uploading your app so I could take a look as to what could be the issue?
I have 4 separate excels as my data source. All of them are not joined. They all might have a "Z" within them. If I was to write this in the script... does it matter where I place it?
I was able to figure it out! Thank you!!
Wonderful! Have a great day!