topic Re: applying different filters based on a message in QlikView

applying different filters based on a message

Wed, 13 Nov 2013 16:36:55 GMT

Hi,

The user asked us to apply different conditions on a table based on a message like this: 'Do you want to include in the analysis the material X?' If I select Yes, the filter Cod_material in (A, B, C, X) will be applied on my calculations, otherwise only the filter Cod_Material in (A, B, C) will be applied. Is this possibile in QV?

If yes, how should I do?

Thanks

Cristina

Re: applying different filters based on a message

Wed, 13 Nov 2013 16:46:00 GMT

Can you Upload an example in excel about that please?

Re: applying different filters based on a message

israrkhan — Wed, 13 Nov 2013 17:02:00 GMT

Hi Cristina,

did not get you properly, but two ideas coming in mind,

1) if you want to add or remove Dimensions and Expressions, like might have you seen in Whats new in qlikview 11 ??

for example, if users select Product, so product will be added as dimension in Straight table, and expression in same way.

if you wana get like so, the see demo on whats new in qlikview 11. you will get it..

2) if you want to include value of a field, in calculation, then create a variable and assign default an empty value, create a button for user to ask, when user clicks yes, then add a trigger and assign the value x in variable, then use this variable in calculation.

OR you can assign a whole expression to variable, when user clicks yes, you can replace with new expression. using trigger.

OR Share a sample , that would be much easier to help....

Re: applying different filters based on a message

christian77 — Wed, 13 Nov 2013 17:18:04 GMT

Hi.

Use the conditional checkboxes and statements in you table dimensions and expressions.

Then you can use variables that change with buttons to make them appear and disappear.

Messages can be in the tip help of buttons, in the tip help of table or just in text boxes.

Salutes.

Re: applying different filters based on a message

Carlos_Reyes — Wed, 13 Nov 2013 17:27:13 GMT

It's probably possible, however that's not the way QlikView works out of the box... so I'd better train the user to do something easier.... SELECTIONS !

It's not my intention to seem rude, but I think it's better to use any tool's defualt behavior than making apps more complex by creating non supported functionality that in the long term will be difficult to mantain.

Re: applying different filters based on a message

Wed, 13 Nov 2013 21:19:01 GMT

I don't mean to change the layout of the table, to hide or show different columns. The layout will remain the same, the calculation the same, only the logic of data extraction will change.

My detail of table is for family group and using the two conditions Cod_material in (A, B, C, X) or Cod_material in (A, B,C) I would include or exclude the material X in analysis.

Maybe I can create a field called Include/Exclude like this one:

if cod_material is in (A, B, C, X) then 'Yes', if cod_material is in (A, B, C) then 'No'

and use it as filter in a list box. But then I wouldn't know how to use it in order to apply the filter.

And even the condition IF won't work because the most values are the same and it'd become confused.

Re: Re: applying different filters based on a message

Carlos_Reyes — Wed, 13 Nov 2013 21:38:02 GMT

Perhaps this is something similar to what you want.

Based on this example, which is what I understood, I still think you could use "Select Excluded" and that kind of QlikView default functionality, but perhaps I don't get exactly what you're trying to do.

Hope it helps!