Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
konkoviv
Partner
Partner

Help With Set Analisis

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

4 Replies
Carlos_Reyes
Partner
Partner

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 )


konkoviv
Partner
Partner
Author

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

Carlos_Reyes
Partner
Partner

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

iktrayanov
Creator III
Creator III

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.