Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnagutha1294
Contributor II
Contributor II

Filter Condition working

Hi All

I am Having A table like below

orginal.png

If i select any filter the valves are changing like below

orginal1.png

Please any one can help me how to resolve it.

Thank You In advance

Krishna.G

9 Replies
arulsettu
Master III
Master III

So the table should not change even if any filter selected?

krishnagutha1294
Contributor II
Contributor II
Author

If you select any filter The valve of that filter won't change.

Kushal_Chawda

What is the expression you are using?

krishnagutha1294
Contributor II
Contributor II
Author

Using the following Expression

Round((Count({<"Commodity Group"={'HDD - Hard Disk Drive','SSD - Solid State Drive','Power Supply'}>} actn_part_srl_nr2)/count(total<[Commodity Group]>BU))*1000000)

+ Round((Count({<"Commodity Group"={'Processor'}>}[ncnfrmc_cd1])/Count(total<[Commodity Group]>BU))*1000000)
+ Round((Count({<"Commodity Group"={'Memory'}>}[ncnfrmc_cd2])/

if(
[Commodity Group]='Memory',
Count({<[Commodity Group]={'Memory'},[Standard Supplier]={'Samsung','SK Hynix','Micron','Kingston'}>}BU),
Count(total<[Commodity Group]>BU))*1000000)
)

 

Kushal_Chawda

looks like the If condition is the problem here. It will change it based on the selections

can you try below

if(
only({1}[Commodity Group])='Memory',
Count({<[Commodity Group]={'Memory'},[Standard Supplier]={'Samsung','SK Hynix','Micron','Kingston'}>}BU),
Count(total<[Commodity Group]>BU))*1000000)
)

Kushal_Chawda

or try wrapping up the if statement or entire expression  with aggr like below

sum(aggr(if(
[Commodity Group]='Memory',
Count({<[Commodity Group]={'Memory'},[Standard Supplier]={'Samsung','SK Hynix','Micron','Kingston'}>}BU),
Count(total<[Commodity Group]>BU))*1000000)
), Osv_category,Month))

krishnagutha1294
Contributor II
Contributor II
Author

Sorry its not working

krishnagutha1294
Contributor II
Contributor II
Author

This one also not working 

Thanks for response 

arulsettu
Master III
Master III

Provide sample app