Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted
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

Highlighted
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,

Highlighted
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

Highlighted
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