New to Qlik Sense

[ibradly]

The filter does not work with the set analysis. It doesn't work for my category and device filters which is in my set analysis. This only happens when i use the set analysis in a KPI. If my set analysis is used in a table the filter works. This is really strange. 

This is my set analysis. 

sum({<Category={'Brand'},Device={'Desktop'},Date={">2019-05-31"}>}Clicks)*0.08 +
sum({<Category=,Category={'Brand ( Desktop)'},Device={'Desktop'},Date={">2019-05-31"}>}Clicks)*0.08 +
sum({<Category={'Brand ( Mobile)'},Device={'Desktop'},Date={">2019-05-31"}>}Clicks)*0.08 +
sum({<Category={'Competition'},Device={'Desktop'},Date={">2019-05-31"}>}Clicks)*0.024 +
sum({<Category={'Oil'},Device={'Desktop'},Date={">2019-05-31"}>}Clicks)*0.032 +
sum({<Category={'Propane'},Device={'Desktop'},Date={">2019-05-31"}>}Clicks)*0.032 +

sum({<Category={'Brand'},Device={'Desktop'},Date={"<2019-06-01"}>}Clicks)*0.2 +
sum({<Category={'Brand ( Desktop)'},Device={'Desktop'},Date={"<2019-06-01"}>}Clicks)*0.2 +
sum({<Category={'Brand ( Mobile)'},Device={'Desktop'},Date={"<2019-06-01"}>}Clicks)*0.2 +
sum({<Category={'Competition'},Device={'Desktop'},Date={"<2019-06-01"}>}Clicks)*0.06 +
sum({<Category={'Equipment'},Device={'Desktop'},Date={"<2019-06-01"}>}Clicks)*0.05 +
sum({<Category={'Oil'},Device={'Desktop'},Date={"<2019-06-01"}>}Clicks)*0.08 +
sum({<Category={'Propane'},Device={'Desktop'},Date={"<2019-06-01"}>}Clicks)*0.08

Can someone please help me? I have been using Qlik sense for a bit but this never happened before.

[sunny_talwar]

Would you be able to share a sample where we can see the issue?

[ibradly]

I dont know how to share a sample.

[sunny_talwar]

You don't know how to attach a sample file you mean?

[ibradly]

I dont know how to create one or attach one. You mean a qvf file? Because the sample file will need my database for me to show you. I dont think i can do that.

[sunny_talwar]

Create a mock up in Excel and/or use an Inline table to replicate it in a sample. Because it is very difficult to know what you might be doing or if it is actually a bug without seeing the behavior. Does that make sense?

[Gopi_E]

Hi ,

here you mentioned 

sum({<Category=,Category={'Brand ( Desktop)'},Device={'Desktop'},Date={">2019-05-31"}>}Clicks)*0.08 

so here if you use Category= then it doesn't take filter from that field.