topic Re: Help With Set Analisis in QlikView

Help With Set Analisis

konkoviv — Tue, 04 Feb 2014 20:23:18 GMT

Good evening.

I have a formula that calculates and depending on the values 1 or 0 exposes.

If (Count (
{<Date = {"= Count ({$ <[MonthDel] * = {1,4,7,10}, SC_Sales_Pcs_Volume = {1}, type = {'Sale'}>} distinct ItemId)> = SKUQty"} >} Distinct Date)> = ShipmentQty, 1,0)

Thus SKUQty may be from 1 to 5.
But it works only when the field is selected filter SKUQty jobs with a single value.
Tell me how to make it so that the formula would automatically inserts all the values SKUQty

Re: Help With Set Analisis

Carlos_Reyes — Tue, 04 Feb 2014 20:30:33 GMT

So... if SKUQty may be from 1 to 5... would you like to sum those values or which would be the rule to choose the correct SKUQty value?

Perhaps you need to use Aggr... something like:

Aggr(

If (Count (
{<Date = {"= Count ({$ <[MonthDel] * = {1,4,7,10}, SC_Sales_Pcs_Volume = {1}, type = {'Sale'}>} distinct ItemId)> = SKUQty"} >} Distinct Date)> = ShipmentQty, 1,0)

,SKUQty )

Re: Help With Set Analisis

konkoviv — Tue, 04 Feb 2014 20:41:37 GMT

Carlos unfortunately your advice did not help. All my Problem is that SKUQty clearly exhibited in the expression without filters so it (the formula is not considered).

Re: Help With Set Analisis

Carlos_Reyes — Tue, 04 Feb 2014 20:47:21 GMT

It'll be easier to help you if you upload a sample qvw. I don't get the exact problem / result expected.

Re: Help With Set Analisis

iktrayanov — Tue, 04 Feb 2014 21:43:40 GMT

Can you spell out what are you trying to do? It isn't clear form your expression. Looks to me that you are comparing count of the distinct date to shipment Qty, that does not look right.