topic SET ANALYSIS question in QlikView

SET ANALYSIS question

sridhar_sigired — Tue, 01 Sep 2015 05:16:57 GMT

Hello,

By default my chart is showing today's data, whereas if user select any product the historical data of that particular product need to display. Suggestion please.

Thanks

Re: SET ANALYSIS question

PrashantSangle — Tue, 01 Sep 2015 05:22:16 GMT

Hi,

Check your set analysis,

In your set analysis have you comparing date= today()

Post your set analysis/Expression.

Regards

Re: SET ANALYSIS question

sunny_talwar — Tue, 01 Sep 2015 05:22:48 GMT

You will need to provide some more details before somebody here can help. What is your current expression? Can you share some sample data?

Best,

Sunny

Re: SET ANALYSIS question

Gysbert_Wassenaar — Tue, 01 Sep 2015 05:24:24 GMT

I suggest you create another chart that shows the historical product data. This chart should get a conditional display expression (on the Layout tab) to show/hide the chart as needed. If the chart should show only when only one product value is selected the conditional expression would be something like =if(GetSelectedCount(Product)=1,1,0)

Re: SET ANALYSIS question

tyagishaila — Tue, 01 Sep 2015 05:26:04 GMT

to solve this issue please provide more information regarding issue.

To get result based on current selection use $ in your expression.

Re: SET ANALYSIS question

sridhar_sigired — Tue, 01 Sep 2015 05:35:48 GMT

Sorry for incomplete information.

I wrote expression like

Sum({$<Date={Today()}>}Sales)

Whereas based on product selection, need to show historical sum of sales for that product. Means except today sales of that product.

Thanks gwassenaar. I will try this way too.

Re: SET ANALYSIS question

sunny_talwar — Tue, 01 Sep 2015 05:40:41 GMT

May be this:

Sum({<Date = {"$(=If(GetSelectedCount(Product) > 0, '<' & Today(), Today()))"}>} Sales)

Re: SET ANALYSIS question

mustafaelryah — Tue, 01 Sep 2015 05:59:17 GMT

Try this :

Sum({$<Date -= {Today()}>}Sales)