Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
jagannalla
Partner - Specialist III
Partner - Specialist III

Filter all fields in table based on input variables

Hi,

Before going to my content can you please see my qvw file...

In my qvw file i had 3 fields A,B,C. I want to filter each field base on input variables.

For Eg:

To filter A, i'm taking vMinA=3 & vMaxA=11 variables in input box.

Now, in table i want to see A field with values between this range 3 to 10 only...

Like this i want to apply for all other fields also at a time.

21 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III
Author

iuliancc,

In your code if i don't load B then i'll face the problem. B'coz i'm loading fields with help of one variable(vFields=A,B,C) i mean like this:

Load

$(vFields)

from table1.qvd;

-


jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Kaushik,

What condition i need to put there Can you plz help me some more.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

   Try this.

    if(isnull(B),0,1)

    Meaning if B is null then dont show else show.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Thanks a lot kaushik it's working...I'll approach you once again if i required anything more.

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

But when i load B also it is hiding kaushik...after keeping condition in presentaiton

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   Try this.

   if(sum(B) = 0,0,1)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Thanks a lot kaushik it's working...I'll approach you once again if i required anything more.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   Please mark this post as answered.

   And incase you have any problem create a new post.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable

Hi Kaushik,

hope u remeber me...u helped me before in solving a problem.........thsi time too i 'm looking towards u

Hi,

I've an expression like: sum(distinct Sales)/1000 in a st. table having 8

dimensions...now the expr can range from 0 to any big value.....i want to create an

input box where the user can enter a number & the expression shud show only the

values  wich are greater than the value entered by the user.

Plz  help

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Offcourse I remember.

     Anyways I would request you to create a new discussion on this topic so that it is not mixed under the current one, and this will help others to solve their issue if they have the same problem.

     Also give me example.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!