Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
antonybi
Contributor

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

Tags (1)
5 Replies
YoussefBelloum
Esteemed Contributor

Re: help needed on selections

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
Valued Contributor

Re: help needed on selections

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

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

antonybi
Contributor

Re: help needed on selections

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
Valued Contributor III

Re: help needed on selections

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
Contributor

Re: help needed on selections

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