1. Create a new table in the script with a new field that you'll use as Dimension
LOAD * INLINE [
...etc, you should get the idea by now
You can use the Period field to make selections in and the appropriate Month values will be used in calculations.
2. Have you tried something like ='Analyse: ' & Only(Year) & ' ' & concat(distinct Month, ' - ' )
3. Set the Show Totals option of that dimension to On.
Thank you for your answer.
For the first point :
I created dimension, but when i use it as filter : my tab is empty. And i dont understand why.
LOAD * INLINE [
2nd point :
Not tested yet, because first point its not ok.
3nd point :
Actually i have in my crosstab
each CA by store
I would like something like that : Create a fake store called 'Total'
and in this 'fake' store have global(ca).
In sql : Select sum(ca), 'total' as store from mytable.
1.) I think it could be useful to associate your data with a master-calendar: How to use - Master-Calendar and Date-Values
2.) getcurrentselections() could be an alternatively to concat
3.) Of course it's possible to create dummy-rows for dimensions (most often added per concatenate load from a small inline-table) but then you need to adjust your expressions for each kind of dimension-values - the normal one, the dummy and maybe a third for the totals. This should be only used if it's really needed - in most cases is the suggestion from Gysbert (enable totals respectively partial sums) the best suitable.
Thank you for your answer. Now First and second point are ok. Solution of Gysbert is ok, its me who do a mistake.
Now i'm looking for my third point.
I understand your point Marcus,I would like to use it anyway
I want in my dashboard a sum by each store and global sum. If you can explain me how, it will be a pleasure.
At last for your 3rd point
In a Table chart like below to get a total row
in the "Aspect" Panel / présentation you have the option to show or hide the total row
Total row can be sum avg max Min or expression
If you want a total Row now in a TCD (crosstabe) look below
i've just add the dimension lib_Regioncom so it's gaving me the total for this region
First for period see attached qvf file : I use variable and qsvariable extension available on qlik branch
So you can have a dynamic period dimension :
hope it helps
Modele.qvf 384.0 K
Thanks both for your answers.
brunobertels wow i would like this. But when i try your QVF i have this error
i can try to translate it in English : Visualization is invalid. Visualization not found on server (which server ?) : variable.
And on the right section : Visualization is invalid, Impossible to edit an invalid visualization.
First go here to dowload the extension named Qsvariable
you will found lots of available extension here :
fallow instruction to install it depending of your qlik version ( desktop or server)
then reload the app and it will be OK
you will see this on the left in graph panel :