topic Re: Help filtering data in QlikView

Help filtering data

Fri, 20 Nov 2020 18:02:30 GMT

To simplify this example, imagine I have a tab with inventory such as:

Name	Actual_price	Price_before
Water	5	4
Beer	8	9
Coke	6.5	6.5
Lemonade	6	6

Then, on a different tab, I want to count the number of items that have the same Actual_price and Price_before (like coke and lemonade in this example).

I'm trying to use something like this Count({<Actual_price={Price_before}>} Name). I'm guessing the solution should be fairly simple, but I've tried different variations without luck, I would appreciate any help.

Re: Help filtering data

Thu, 26 Jul 2012 10:28:39 GMT

Try Like:

Count(If(Actual_price=Price_before,Name,0))

If( Actual_price=Price_before,Count(Name),0)

Regards

Re: Help filtering data

Anonymous — Thu, 26 Jul 2012 10:29:17 GMT

If these are in the same table, you can just add a flag for this as a field in the script:

If(Actual_price=Price_before,1,0) as SamePriceFlag

Then you can use Set Analysis to count the number of products with the same before and after price:

Sum({$<SamePriceFlag={1}>} SamePriceFlag)

Re: Help filtering data

Sokkorn — Thu, 26 Jul 2012 10:30:23 GMT

Hi biel.II.s,

Let do this IF(Actual_price=Price_before,COUNT([Name]))

Do let me know after you tested it.

Regards,

Sokkorn

Re: Help filtering data

Thu, 26 Jul 2012 10:57:51 GMT

Johannes, thank you for your answer, it's exactly what I was looking for and it simplifies things a lot.

Re: Help filtering data

Thu, 26 Jul 2012 12:02:28 GMT

lakhina007, thank you for your answer, but it didn't work as I had in mind.