topic Re: Using identifiers and modifiers in QlikView

Using identifiers and modifiers

Tue, 27 May 2014 09:34:50 GMT

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

Period	Value
1	10
2	10
3	10
4	10
5	10
6	10
7	10
8	10
9	10
10	10
11	10
12	10

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

Re: Using identifiers and modifiers

Anonymous — Tue, 27 May 2014 09:41:11 GMT

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

Re: Using identifiers and modifiers

jvitantonio — Tue, 27 May 2014 09:41:20 GMT

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,

Re: Using identifiers and modifiers

Tue, 27 May 2014 10:20:27 GMT

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

Re: Using identifiers and modifiers

jvitantonio — Tue, 27 May 2014 10:22:43 GMT

The right syntax is:

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

Re: Using identifiers and modifiers

Tue, 27 May 2014 10:25:26 GMT

That is the right solution! many thanks!

Re: Using identifiers and modifiers

Anonymous — Tue, 27 May 2014 10:32:30 GMT

Hi Janne,

don't put any thing after = sign

try this.

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

Thanks & Regards,

Kiran Kokade

Re: Using identifiers and modifiers

sasikanth — Tue, 27 May 2014 10:35:47 GMT

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