topic Re: Calculated Formula in Script in QlikView

Calculated Formula in Script

Tue, 16 Sep 2014 14:35:25 GMT

Hey all,

I have defined a variable as follows on the surface (not in the script):

SUM({<S_Artikel.Statistik = {'yes'} >}Scanning.UMSATZ) -SUM({<S_Artikel.KontenGruppe = {"UMSCN"}>}Scanning.UMSATZ)

Now I want this definition in the script, so I can define this formula as a Dimension in the Table "S_Artikel". On the surface I want to make a Listbox where I can choose this dimension.

Is there a way I can do this. The only way I can think of is a "mapping load" of the Scanning.UMSATZ into the S_Artikel.

I hope it was not too confusing 🙂

Best

Re: Calculated Formula in Script

marcus_sommer — Tue, 16 Sep 2014 15:38:20 GMT

It will be depend from your datamodel but I think you will need to merge all neccessary fields into a single table. But why want you this transfer into the script - especially these kind of expressions is often better used within the gui and not in the script. If you have already problems with your performance you will rather need a different approach in your datamodel.

- Marcus

Re: Calculated Formula in Script

Mon, 29 Sep 2014 14:25:30 GMT

Hi marcus,

I have merged alle necessary fields into one table. The challenge here the fact that I want the second SCANNING.Umsatz substracted from the first SCANNING.Umsatz.

What I want is a dimension like

if (S_Artikel.Statistik = 'yes' or S_Artikel.KontenGruppe = 'UMSCN', 'Teilegruppenstatistik') as S_Artikel.Dimension

In future I want to build a cascaded if-clause, where I can refer to some possible variations in a listbox.

As I said, the challenge here is that the second part of the if-clause (S_Artikel.KontenGruppe = 'UMSCN') is substracted from the first part (S_Artikel.Statistik = 'yes')

Perhaps I can provide a sample-qvw.

Hannes