topic Re: help needed on selections in QlikView

help needed on selections

antonybi — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: help needed on selections

YoussefBelloum — Fri, 29 Jun 2018 09:31:16 GMT

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.. ?

Re: help needed on selections

kakani87 — Fri, 29 Jun 2018 09:39:57 GMT

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

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

Re: help needed on selections

antonybi — Fri, 29 Jun 2018 09:47:50 GMT

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.

Re: help needed on selections

sasikanth — Fri, 29 Jun 2018 09:49:34 GMT

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,

Re: help needed on selections

antonybi — Fri, 29 Jun 2018 10:05:06 GMT

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