Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using identifiers and modifiers


Hi,

I am working with a sales report and I would need to show not only period and YTD figures but also full year figures.

What kind of set analysis I would need to write to be able to show full year figures? I would need to somehow be able to ignore period selection but include the year selection.

so below is simple example

PeriodValue

1

10
210

3

10
410
510
610
710
810
910
1010
1110
1210

So let's assume now it is period 5. My report should show periodic value 10, YTD value 50 and full year figure 120. How can I get that 120? it doesn't work with identifier full set 1, because then I would ignore all selections done and I would get data from previous years also. How to write: I want sum of seleceted year and ignore month selection?

Thanks

Regards

Janne

1 Solution

Accepted Solutions
jvitantonio
Luminary Alumni
Luminary Alumni

The right syntax is:

sum({$<Period= >} [Value] )


JV

View solution in original post

7 Replies
kirankkk
Creator II
Creator II

If you just want to ignore period in current selection you can simply write in modifier

{$<period = ''>Value}.so it ignore period filter.

Thanks & Regards

Kiran Kokade

jvitantonio
Luminary Alumni
Luminary Alumni

Hi, try this:

1) sum( {< Period = {"$(=max(Period))"}    >} Value)   --> current period

2) sum( {< Period = {" <=$(=max(Period))"}    >} Value)   --> YTD

3) sum(  Value) for ALL periods. If you have different years then try:

sum( {< Period = , Year = {"$(=max(Year))"} >} Value)

Thanks,

JV

Not applicable
Author

Hi and thanks!

I think you are showing here the simple solution that I am looking for. However, it doesn't work

I have now following script:

sum({$<Period=''>[Value]})

This doesn't work. I know I may have a stupid error there but I can't make this work

Thanks

Regards

Janne

jvitantonio
Luminary Alumni
Luminary Alumni

The right syntax is:

sum({$<Period= >} [Value] )


JV

Not applicable
Author

That is the right solution! many thanks!

kirankkk
Creator II
Creator II

Hi Janne,

don't put any thing after = sign

try this.

sum({$<Period=>[Value]})


Thanks & Regards,

Kiran Kokade



sasikanth
Master
Master


Hi janne

try some thing like

sum({< period ={"$(=max(period))"}>} value)  --> for current Period

sum( {< period ={"<=$(=max(period))"}>} value)   --> For YTD

sum({<period= >} value)      -----> For total sum irrespetive of the Period