topic Re: About variables (loading script) and calculating exp in QlikView

About variables (loading script) and calculating exp

alex900 — Wed, 25 Nov 2020 16:16:04 GMT

Hello. I will try to describe an issue and hope someone could help me. I am new to it

1. I have a copy of a spreadsheet with formulas (textboxes and so one). Original project was fully functional. This project ( a copy i am speaking of) has a lot of variables, wich i need to add and recalulate.

Example.

I have a file (qvo) with such structure (let name be "Table1"):

value fild 1| value field2 | value field 3|

Yes asdasd 1111

No treasd 2231

So now i need to calc unique values of field2 and print them somewhere. I can do it like

=Count(DISTINCT [value field2]) and it works good.

This is way i rewrite it

But originaly this was with variable like

=(Count(DISTINCT $(vField2Count)) and it worked and did the same.

It is dynamic.

I think this Variable vField2Count was assigned like with every field of that column.Think it was loading at the load script.

I need to do it like this as this variables are using across all project.

Hope you understand me. Thx

Re: About variables (loading script) and calculating exp

Vegar — Thu, 07 May 2020 05:50:42 GMT

What is the output of the $(vField2Count)?

A) value field2

B) [value field2]

If A then you need to add brackets in your expressions like this:

=(Count(DISTINCT [$(vField2Count)])

Re: About variables (loading script) and calculating exp

alex900 — Thu, 07 May 2020 06:00:58 GMT

i dont know what is the output of this value as now a project for what it was imported didnt acceptable now.

but the output of Count(DISTINCT [value field2]) is equal ot (Count(DISTINCT $(vField2Count)) of previous project

so both of that expression should calculate unique values

I am sure 1000000% that the original expression was = Count(DISTINCT $(vCheckCount)) without [ ]

Re: About variables (loading script) and calculating exp

alex900 — Thu, 07 May 2020 06:04:47 GMT

I think i should somehow assing vField2Count variable to each value of the fields wich i count..

so if my table is

value fild 1| value field2 | value field 3|

Yes asdasd 1111

No treasd 2231

my variable should be assigned with column " value field2"

smth like" value field2" = "vField2Count"

Re: About variables (loading script) and calculating exp

alex900 — Thu, 07 May 2020 06:12:11 GMT

Maybe to use Peek somehow?

Re: About variables (loading script) and calculating exp

Vegar — Thu, 07 May 2020 06:31:12 GMT

Is the field name the same as well? You only need brackets when you have field names with spaces, like [Field Name]. It's not necessary for fields without spaces like FieldName.

Re: About variables (loading script) and calculating exp

alex900 — Thu, 07 May 2020 06:40:47 GMT

i know it but it is not about i am asking of.

i dont know how to assing variable "vField2Count" with values of field named " value 2 field"

Re: About variables (loading script) and calculating exp

alex900 — Thu, 07 May 2020 06:43:45 GMT

i understood about u telling but i did it already ( wrote about it at the 1st post)

but i want assing variable with field

Re: About variables (loading script) and calculating exp

alex900 — Thu, 07 May 2020 06:55:51 GMT

i uploaded file to understand it better what i mean

test.xlsx as date source but i think it is not neccesary

Re: About variables (loading script) and calculating exp

Vegar — Thu, 07 May 2020 07:49:39 GMT

Im sorry but your examples didn't help me to understand your issue. The script and the excel are not related. Please explain.

Maybe I am over thinking your problem. YOu just want to manually declare the variable vField2Count? If so then just write this in your script.

LET vField2Count = '[Value Field 2]';

Re: About variables (loading script) and calculating exp

alex900 — Thu, 07 May 2020 08:14:40 GMT

this is exactly what i needed!

I think i described problem very complicated!!

Thank you very much