Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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
Luminary
Luminary

Re: Using identifiers and modifiers

The right syntax is:

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


JV

View solution in original post

7 Replies
kirankkk
Contributor II

Re: Using identifiers and modifiers

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

Luminary
Luminary

Re: Using identifiers and modifiers

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

Re: Using identifiers and modifiers

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

Luminary
Luminary

Re: Using identifiers and modifiers

The right syntax is:

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


JV

View solution in original post

Not applicable

Re: Using identifiers and modifiers

That is the right solution! many thanks!

kirankkk
Contributor II

Re: Using identifiers and modifiers

Hi Janne,

don't put any thing after = sign

try this.

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


Thanks & Regards,

Kiran Kokade



sasikanth
Valued Contributor III

Re: Using identifiers and modifiers


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