topic Re: Set Analysis Question. in QlikView

Set Analysis Question.

MuraliPrasath — Tue, 28 Jul 2015 04:11:18 GMT

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.

Re: Set Analysis Question.

PrashantSangle — Tue, 28 Jul 2015 04:26:05 GMT

Hi,

yes This is functionality of QlikView.

What are trying to acheive???

Regards

Re: Set Analysis Question.

Tue, 28 Jul 2015 04:33:05 GMT

Hi,

Try this

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

Re: Set Analysis Question.

PrashantSangle — Tue, 28 Jul 2015 04:41:16 GMT

Hi,

If you want to avoid selection of CarFamily.

Then try detached or Read Only option.

Regards

Re: Set Analysis Question.

MuraliPrasath — Tue, 28 Jul 2015 05:46:09 GMT

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.

Re: Set Analysis Question.

Tue, 28 Jul 2015 06:21:51 GMT

Hi,

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

Re: Set Analysis Question.

Tue, 28 Jul 2015 06:29:50 GMT

Hi,

By pass the dimensions on this expression.

Regards

Vimlesh

Re: Set Analysis Question.

jonathandienst — Tue, 28 Jul 2015 06:46:23 GMT

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

Re: Set Analysis Question.

MuraliPrasath — Tue, 28 Jul 2015 06:50:23 GMT

Hi Jonathan,

My vToday is defined like this..

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

Re: Set Analysis Question.

sasiparupudi1 — Tue, 28 Jul 2015 06:54:56 GMT

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

Re: Set Analysis Question.

jonathandienst — Tue, 28 Jul 2015 06:55:35 GMT

Ok, so its not the variable. I suggest that you post your qvw or at least a sample illustrating the problem.

BTW - your variable should be defined:

LET vToday = Num(Today(1)));

(The Date() function here does nothing)

Re: Set Analysis Question.

MuraliPrasath — Tue, 28 Jul 2015 07:31:19 GMT

Hi,

Please help me here is my example Qvd and Spreadsheet.

Correct my Pie-Chart Expression. I don't need any selections. Pie-chart should ignore all the selections on the dashboard.

Re: Set Analysis Question.

MuraliPrasath — Tue, 28 Jul 2015 07:59:32 GMT

Hi Vimlesh,

Pls see below, I've uploaded the Qvw and flatfile. Pie-Chart should ignore all the selections on the dashboard.

Thanks in advance.

Re: Set Analysis Question.

sasiparupudi1 — Tue, 28 Jul 2015 08:00:03 GMT

May be try

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

Re: Set Analysis Question.

MuraliPrasath — Tue, 28 Jul 2015 08:04:51 GMT

still no luck !!

Re: Set Analysis Question.

Tue, 28 Jul 2015 08:30:18 GMT

Hi Murali,

you are using Day rather than a date field in your set analysis, which is causing you problems.

Use

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

and just an FYI you have no data for the today set in the example, you nee dot go back to 23rd July to show some data

hope that helps

Joe

Re: Set Analysis Question.

sasiparupudi1 — Tue, 28 Jul 2015 08:31:55 GMT

I am getting the following output when I use the expression

sum({1<CarFamily=,DeliveredQty=,DistChannel=, ShipmentStatus={'COMPLETED'}, Date={"=date($(vToday),'MM/DD/YYYY')"}>}DeliveredQty)

and the pie chart does not change with the selections.Is this what you are expecting to see for todays date?

Re: Set Analysis Question.

Tue, 28 Jul 2015 09:52:25 GMT

FYI 'Date' isn't a field in the data model so that section of the set analysis isn't doing anything.

So you are actually getting all Completed QTY for the entire data set, not all Completed QTY for today

Joe

Re: Set Analysis Question.

Anonymous — Tue, 28 Jul 2015 22:25:37 GMT

I like Joe's answer. If you have an actual shipment date to use for DATE, this works perfectly.