Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Expressions

Table1:

 

   

IDFixedStatusTest_Datevalues
100Napproved8/8/2016Text
200Napproved26/05/2016Text1
300Napproved27/05/2016Text1
400Napproved10/10/2016Text1
500NReject10/12/2016Text4
500YReject10/12/2016Text4

   

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.

4 Replies
sinanozdemir
Valued Contributor III

Re: Expressions

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
Valued Contributor

Re: Expressions

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,

Not applicable

Re: Expressions

   

IDFixedStatusTest_DatevaluesDate
100Napproved8/8/2016Text8/8/2016
200Napproved26/05/2016Text126/05/2016
300Napproved27/05/2016Text127/05/2016
400Napproved10/10/2016Text110/10/2016
500NReject10/12/2016Text410/12/2016
500YReject10/12/2016Text410/13/2016

Dimension is Date field

and we can use count

Not applicable

Re: Expressions

   

IDFixedStatusTest_DatevaluesDate
100Napproved8/8/2016Text8/8/2016
200Napproved26/05/2016Text126/05/2016
300Napproved27/05/2016Text127/05/2016
400Napproved10/10/2016Text110/10/2016
500NReject10/12/2016Text410/12/2016
500YReject10/12/2016Text410/13/2016

Dimension is date

today date should be greater than the Test_Date-60 

Distinct ID can be used instead of amount

Community Browser