topic Re: want to filter calculated value in QlikView

want to filter calculated value

ferha_jafri — Thu, 22 Aug 2013 07:09:25 GMT

Hello Everyone,

I have a scenario as per which i want to create a filter for sales such that its value get change for a filter for sales amount >=10000 through an input box such that the straight table show the values when sales>=10000 otherwise it should show a complete table.

Thanks in advance

Ferha Jafri

Re: want to filter calculated value

tresB — Thu, 22 Aug 2013 07:27:49 GMT

May be something like this:

store input in a variable say, vInput. Now the calculation expression:

If(Sum(Sales)>=vInput,Sum(Sales))

Edit: missed last brace

Re: want to filter calculated value

Thu, 22 Aug 2013 07:31:18 GMT

Hi,

You can try like below.

Here SalesRange is Inputvariable

MonthDec is Dimension.

if(SalesRange >= 2000, if(Aggr(sum(Sales),MonthDec)> SalesRange, aggr(sum(Sales),MonthDec),Null()), Aggr(sum(Sales),MonthDec))

Re: want to filter calculated value

Andrea_Ghirardello — Thu, 22 Aug 2013 07:45:41 GMT

Hi,

try the attached example.

To see all products just leave the Condition variable empty. To see filtered rows, just write a formula like > 1500.

Re: want to filter calculated value

kaushiknsolanki — Thu, 22 Aug 2013 08:05:34 GMT

Hi,

Try this Expression.

Sum({<Product = {"=sum(Sales)<=$(Condition)"}>}Sales)

And enter 1600 as the variable value and see the diff.

Regards,

Kaushik Solanki

Re: want to filter calculated value

Andrea_Ghirardello — Thu, 22 Aug 2013 08:36:59 GMT

Hi,

Thanks for your reply.

Interesting and it maybe a solution...depends on results Ferha Jafri needs to obtain.

My example is a general formula...you can write <, <=, >, >= and it works without changing the expression.

The formula you wrote needs a value for $(Condition) otherwise the chart will be populated with 0 for each product.

Re: want to filter calculated value

ferha_jafri — Thu, 22 Aug 2013 11:53:44 GMT

But when the input box is empty i m not getting any value although i want the table to remain as it is when nothing entered in the input box.

Re: want to filter calculated value

kaushiknsolanki — Thu, 22 Aug 2013 12:44:53 GMT

Hi,

Try this.

Sum({<Product = {"=if(not isnull($(Condition)),sum(Sales)<=$(Condition),'*')"}>}Sales)

Regards,

Kaushik Solanki

Re: want to filter calculated value

Thu, 22 Aug 2013 12:55:43 GMT

Hi Ferha,

Please find the attachment. This is one of the possible solution.

Regards,

Santhosh G

Re: want to filter calculated value

ferha_jafri — Tue, 27 Aug 2013 04:57:35 GMT

Thank you so much it worked..