Set Analysis Question.

[MuraliPrasath]

Hi,

I've a Expression like this in Pie Chart.

sum({1<ShipmentStatus={'COMPLETED'}, Day={"=date($(vToday))"}>}DeliveredQty)

My question is, I have used '1'.  It should be ignoring ALL selections except for what I specified.  but if I select the CarFamily(this is the deminsion for Pie Chart)  it changes.

[PrashantSangle]

Hi,

yes This is functionality of QlikView.

What are trying to acheive???

Regards

[#3]

Hi,

Try this

sum({1<ShipmentStatus={'COMPLETED'}, CarFamily=,Day={"=date($(vToday))"}>}DeliveredQty)

[PrashantSangle]

Hi,

If you want to avoid selection of CarFamily.

Then try detached or Read Only option.

Regards

[MuraliPrasath]

Hi Reshma,

Now it is working but still this Expression is not fulfilled my requirement. If I select any other list box field also this Pi-chart values get changes.

[#6]

  Hi,

Can you give more clarity on the requirement by given the data model or the qvw

[#7]

Hi,

By pass the dimensions on this expression.

Regards

Vimlesh

[jonathandienst]

How is vToday defined? Your selections may be changing the variable value.

[MuraliPrasath]

Hi Jonathan,

My vToday is defined like this..

LET vToday = Num(Date(today(1), 'MM/DD/YYYY')); 

[sasiparupudi1]

What are the other list box fields? could you post your application so that we can advise you properly?