Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist III
Specialist III

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
Specialist
Specialist

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
Author

   

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
Author

   

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