Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
antonybi
Creator
Creator

help needed on selections

Hi All,

In country filter and I have excluded UK by using below condition

=If(Match(Country,'UK'),Null(),Country)

Also In the chart expression I have excluded Country UK

by using setanalysis{<Country=-{'UK'}>}

dim: Country

exp; Sum({<Country=-{'UK'}>}VAL)/SUM({<Country=,brand=>}Total VAL)

Now If select any other Country in filter box

then chart is not showing anything(Only its showing '-').

Problem with expression in the list box

If I remove the condition from list box that is working fine  

my dim and exp is some thing like below

dim: Country

exp; Sum({<Country=-{'UK'}>}VAL)/SUM({<Country=,brand=>}Total VAL)

Please suggest where I did wrong.

Any suggestions will be appreciated.

Thanks

5 Replies
YoussefBelloum
Champion
Champion

Hi,

would you be able to share sample app? I've created a test app with the same filterbox (same expression) and same chart (with same expression) and it is working fine.

maybe there is something else missing which is not described above.. ?

kakani87
Specialist
Specialist

In set expression try like this by placing - symbol before = i.e -=

{<Country-={'UK'}>}

antonybi
Creator
Creator
Author

Issue with in list box when I select any Country then all the values are going off in the corresponding chart.

I have excluded Country UK in both list box and Chart

In the Country list box I have used below condition

=If(Country='UK',null(),Country)

dim is Country and Brand

and expression is

(sum(  {<[Respondent Dim Key%]=e({$<[Brand Net Multiplier]={'-1'}>}),Year=,Month=,Brand=,Country=-{'UK'},

[Measure ID]={1000},Yardstick={'R3M'},ComparisonType={"None"}>}

    [Respondent Weight])

/

Sum( {<[Measure ID]={327},Country=,Brand=,[Imagery ID]=,[KPI Name]=,[Top Statement?]=,Ys={'R3M'}>}

Total<RollingMonth,Brand> [Respondent Weight]))*100

Kindly help as so needful.

sasikanth
Master
Master

Try this,

Dim: Country

exp; Sum({<Country={'*'}-{'UK'}>}VAL) / SUM({<Country=,brand=>}Total VAL)

you can even select UK in the country Listbox but it will display Zero as it becomes empty set.

Thanks,

antonybi
Creator
Creator
Author

Please suggest did I wrong anything in both expressions ???