Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm wondering if there is some sort of equivalent to the variance sql function? I.e., a way for me to get 1.66 from this data as you would if you ran this sql
CREATE TABLE #foo(f_val int)
INSERT INTO #foo VALUES(1), (2), (3), (4)
SELECT var(f_val) FROM #foo
You can define a variable (not in the expression window, but either in the script or in the variable overview in the UI).
For example, add to your script:
SET vCount = Count(ItemMeasure)/Count(ExamMeasure);
Then you can use the variable in your chart expressions:
=($(vCount)) / ($(vCount) - 1)
The Magic of Dollar Expansions
To get you up and started, I would recommend that you go through some free tutorials that Qlik offers
or since most of the language is shared with QlikView
QlikView 11 Developer Tutorial
Or grab a good book
Have fun!
Is the variable in the UI an extension? I vaguely remember reading something about that.
No, I don't think so.
If you want to modify the variable in the UI as a user (accessing the app in the accesspoint), you need(ed?) an extension.
This is the only variable thing I've ever known of, and we had to install it as an extension. http://i.imgur.com/Asjc2yl.png
Enter edit mode of your app, then you can find the variable overview:
Great, I'll check that out tomorrow. Thanks again for all your help!