Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
NavinReddy
Contributor II

Expression Error

Hello All,

Below expression working for other charts, for attached QVW chart its not working.

please help me know what was the wrong im doing

Thanks in Advance

Niranjan Powar

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Expression Error

your Expression Count( {<[Issue Creation Date]={">=$(=vLast3Quarter) <=$(=vYourMaxDate)"}>} [Issue ID]) works in the Chart

I have dimensions Issue Name1 and Quarter and your Expression!

when I select 10/12/2018 I get this Chart which is correct, as theere are NO data in 2018 with an other Issue Name1

please look at your raw data for 2018 that there is no other data

when I select 11/1/2017 I get this Chart

View solution in original post

10 Replies
Highlighted
Partner
Partner

Re: Expression Error

your variable vLast2Quarter has en empty line before definition

delete the first row and it works

Highlighted
NavinReddy
Contributor II

Re: Expression Error

Thanks for your reply, I have removed the extra space still its not working for me

Highlighted
Partner
Partner

Re: Expression Error

what is your expected Output? can you explain?

using your qvw I see that in the daterange 4/1/2018 to 7/1/2018 there are NO Issue Name 1 (only nulls)

in total we have 616 (distinct 403)

Highlighted
NavinReddy
Contributor II

Re: Expression Error

Could you please check another chart with simple expression im getting the data.

On Second chart data im expecting on first chart.

Untitled.png

Highlighted
Partner
Partner

Re: Expression Error

the second Chart Shows all data over all years while the first Chart only Shows the last quarter

when you restrict your Issue Creation Date to 4/1/2018 to 7/1/2018 you get the same results

so do you want to show same results in both Charts? right now you compare different!

first Chart without date restriction

Highlighted
NavinReddy
Contributor II

Re: Expression Error

Based on current selections i wast to display the data on chart current 3 Quarters

Highlighted
Partner
Partner

Re: Expression Error

your variables vLast3Quartal and vLast2Quartal selects 1 quarter

your Expression allows only the data from 1 quarter,

now you say that you want 3 quarters?

so can you explain more in Detail how the final Chart should Show?

you select a date from [Issue Creation Date] and then the previous 3 quartals

should be shown?

Highlighted
NavinReddy
Contributor II

Re: Expression Error

i have created the current Quarter variable and below expression gives me 3Quarters information.

On Dimentions column i can see blank data,please help me any issue with my dimention

Count( {<[Issue Creation Date]={">=$(=vLast3Quarter) <=$(=vYourMaxDate)"}>} [Issue ID])

Highlighted
Partner
Partner

Re: Expression Error

your Expression Count( {<[Issue Creation Date]={">=$(=vLast3Quarter) <=$(=vYourMaxDate)"}>} [Issue ID]) works in the Chart

I have dimensions Issue Name1 and Quarter and your Expression!

when I select 10/12/2018 I get this Chart which is correct, as theere are NO data in 2018 with an other Issue Name1

please look at your raw data for 2018 that there is no other data

when I select 11/1/2017 I get this Chart

View solution in original post