Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for
Did you mean:
MVP

## variable with "And"

Hi all,

i want to use And  with variable  below is my expression giving wrong result.

logic:  if(qtr=MaxQtr  and qtr =qtr, frcst+act)

if(Quarter=vMaxQtr and Quarter=Quarter,\$(vFc)+\$(vAc))

how to write this in correct way?

thanks

chanty

1 Solution

Accepted Solutions
Creator III

Try this:

if(Quarter=vMaxQtr and Quarter=Quarter,'\$(vFc)'+'\$(vAc)')

Father/Husband/BI Developer
8 Replies
Creator III

Try this:

if(Quarter=vMaxQtr and Quarter=Quarter,'\$(vFc)'+'\$(vAc)')

Father/Husband/BI Developer
MVP
Author

Not working

MVP

What is Quarter = Quarter means? On a single row... Quarter will always equal to Quarter....

MVP
Author

logic is    the selection is   multiple values  then sum

it means  maxquarter and anyother quarter

example: 2018Q3+ any quarter selected  else part should take

MVP

Chanty bhai, I have no idea what you are trying to say.... do you want to may be share few rows of dummy data to show what you have and what you are looking to do with it?

MVP
Author

i have quarter field values

2018Q3

2018Q2

2018Q1

--

---

2017Q3

so when user selected two quarters from the listbox the else part should work

MVP