topic Re: Expressions in QlikView

Expressions

Thu, 26 May 2016 14:10:20 GMT

Table1:

three bar charts can be displayed on below 3 conditions

1)Where Status = approved

Fixed = 'N'

today date is greater than the Test_Date-60 (bar chart)

2)Where status = approved

Fixed = 'N'

today date is is greater than the Test_Date (bar chart)

3)Where Satus = Reject

Match where the role has Text4 (bar chart)
Could you please help on above three set expressions.

sinanozdemir — Thu, 26 May 2016 14:19:22 GMT

Hi reddy,

What is the dimension you want to use and what function do you want to use in the expressions SUM, COUNT, etc?

Thanks

santiago_respane — Thu, 26 May 2016 14:38:31 GMT

Hi reddy,

i dont know which kind of aggregation you want to use in your expression nor which field but your expression will look something like this:

Lets say you will use a sum operation for the field amount...(you can change them).

1. =SUM( {<Status={"aprooved"},Fixed={"N"},Test_Date={"<$(=Date(Today()-60, 'D/M/YYYY'))"}>} Amount)

2. =SUM( {<Status={"aprooved"},Fixed={"N"},Test_Date={"<$(=Date(Today(), 'D/M/YYYY'))"}>} Amount)

3. =SUM( {<Status={"Reject"},Values={"Text4"}>} Amount)

It not that easy to create the expression with the little information you provided.

Please let me know if this helps.

Kind regards,

Fri, 27 May 2016 05:57:59 GMT

Dimension is Date field

and we can use count

Fri, 27 May 2016 05:59:25 GMT

Dimension is date

today date should be greater than the Test_Date-60

Distinct ID can be used instead of amount