topic Re: expression and variable does not work in QlikView

expression and variable does not work

Wed, 18 Mar 2015 09:47:55 GMT

Hello,

I want to make a straight table, like in the image (see attachment).

The problem is, I have no data in the straight table. All labels give number zero.

Can someone help me? Is something wrong with the variable or expressions?

Thanks in advance.

First I have make a variable in the variable overview:

Name variable:

vSetPreviousNMonth

The variable definition is:

PeriodID = {$(=Max(PeriodID) – $1)},

Year = ,

Quarter = ,

Month = ,

Period =

Then I have make a straight table: "Carrier Group" as the dimension.

And I have add the three expressions:

1. label: Current Month Flights,

expression:

Sum({$<$(vSetPreviousNMonth(0))>} [# Departures Performed])

2. label: Flights Previous Month

expression:

Sum({$<$(vSetPreviousNMonth(1))>} [# Departures Performed])

3. label: Flights Two Months Ago

expression:

Sum({$<$(vSetPreviousNMonth(2))>} [# Departures Performed])

Re: expression and variable does not work

PrashantSangle — Wed, 18 Mar 2015 09:58:59 GMT

Hi,

just check in Text Object that Your variable returning any value or not.

In text Object write

=vSetPreviousNMonth

Regards

Re: expression and variable does not work

awhitfield — Wed, 18 Mar 2015 10:00:12 GMT

Looks like you are using the Qlikview for Developer books, but I'm not sure what you actual issue is , as the screen shot looks to be correct when compare to my copy of the dashboard.

Andy

Re: expression and variable does not work

jyothish8807 — Wed, 18 Mar 2015 10:01:33 GMT

Hi Michel,

First of all what is Period ID ? Is it is date format or in month format ?

Assuming it is in month format:

Create a variable:

let vMonth=month(max(PeriodID))

Now in your straight chart:

Expression1:

sum({PeriodID={'$(=vMonth)'}[#Depature Performed])

Expression2:

sum({PeriodID={'$(=vMonth-1)'}[#Depature Performed])

Expression3:

sum({PeriodID={'$(=vMonth-2)'}[#Depature Performed])

Hope it works

Regards

Re: expression and variable does not work

pavendhan — Wed, 18 Mar 2015 10:30:10 GMT

Try this,

In the load script add one column

num(AutoNumberHash256(year(Datecolumn) & month(Datecolumn)),'00') AS HashYearMonth,

1. label: Current Month Flights,

expression:

=Sum({<HashYearMonth= {$(=max(HashYearMonth))}>}[# Departures Performed])

1. label: Previous Month Flights,

expression:

=Sum({<HashYearMonth= {$(=max(HashYearMonth)-1)}>}[# Departures Performed])

3. label: Flights Two Months Ago

expression:

=Sum({<HashYearMonth= {$(<max(HashYearMonth)-2)}>}[# Departures Performed])