topic Re: Expression Error in QlikView

Expression Error

NavinReddy — Thu, 25 Oct 2018 07:16:11 GMT

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

Re: Expression Error

Anonymous — Thu, 25 Oct 2018 07:30:35 GMT

your variable vLast2Quarter has en empty line before definition

delete the first row and it works

Re: Expression Error

NavinReddy — Thu, 25 Oct 2018 08:17:32 GMT

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

Re: Expression Error

Anonymous — Thu, 25 Oct 2018 08:40:15 GMT

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)

Re: Expression Error

NavinReddy — Thu, 25 Oct 2018 09:28:45 GMT

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

On Second chart data im expecting on first chart.

Re: Expression Error

Anonymous — Thu, 25 Oct 2018 09:37:30 GMT

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

Re: Expression Error

NavinReddy — Thu, 25 Oct 2018 09:50:52 GMT

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

Re: Expression Error

Anonymous — Thu, 25 Oct 2018 10:05:38 GMT

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?

Re: Expression Error

NavinReddy — Thu, 25 Oct 2018 11:40:01 GMT

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])

Re: Expression Error

Anonymous — Thu, 25 Oct 2018 11:51:25 GMT

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

Re: Expression Error

NavinReddy — Thu, 25 Oct 2018 12:13:13 GMT

Thank you sir its working