How to apply filters ?

[#1]

Hi Guys,

I have to generate a report.

Two columns should have data upon the filter criteria.

For both the columns the filter criteria conditions will be different.

I want to know how to apply a filter pane or some filter box for this columns ?

[Anonymous]

girishinani if you are talking about filter pane then the question should be in qlik sense. if you are talking about list box then you have posted it in the right place.  Need some more detail info about your requirement. Please post your sample file so that we can better assist you.

[#3]

Hi,

Thanks for your reply.

Can i apply two list boxes of same field ?

Eg.

Date is one field.

A and B columns depends on Date field.

I want one filter Date for A and one filter Date for B.

If A is Bid value depends on first date  - User should able to select first date.

If B is Bid value depends on last date - User should able to select last date.

Note : Bid value is one more field.

My question is how the user can select first date and last date and depending on that accordingly A and B column should populate the data.

[Anonymous]

This is how you can do. There is a concept called as input box. First create two variables whose output should be in the format of date of your date column ( most of developers define this variables in script like see below) .Then create two input boxes with these two variables defined. So now the user

Variable declaration in script:

LET EnterDate=date(today());

LET vDueDate=date(today()-15);

Screen shot showing input variables: So declare two input boxes one with start date and another with lastdate.

Now you can use these variables in the set analysis in the chart: see screen shot below:

expression:

Sum({<AccountingDate ={"<=$(vDate)"}, DueDate={"<=$(vDueDate)"}

>}  InvoiceAmount)

[#5]

Thanks for your reply.

I have written following expression

Sum({<QUOTE_DATE = {"<=$(vDate)"}>} BID)

QUOTE_DATE and BID are columns and which have data.

vDate is a variable - Timestamp(Max(QUOTE_DATE)-1)

QUOTE_DATE is also in Timestamp

But the data populating by this expression is zero.

Please help.

[Anonymous]

Make sure variable vDate  date format & your QUOTE_DATE date format is similar. As a check what you can do is put that variable in a text box and see how the output is coming. Otherwise, post a sample QVW file i can be able help you