Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

GetFieldSelections and Dynamic Title and rangesum()

Hello Everybody,

I'm a student, and i'm a newbie. i discovered qliksense desktop yesterday.

i dont find in forum my answer. so i will try to post here and i hope to have answer

My input file is Excel. In this file i have worksheet  "calendrier" wich contains :

date(dd-mm-yyyy) / year / month .

In Load script i did :

LOAD

    idTemps,

    date,

    jour,

    mois,

    annee,

    li_mois,

    (annee&'-'&if(len(trim([date]))>0, 'S'&num(ceil(month([date])/6)))) as annee_semestre,

    (annee&'-'&li_mois) as annee_mois,

    (annee&'-'&if(len([date])>0, 'T' & ceil(month([date])/3))) as annee_trimestre

 

 

 

FROM [lib://ProtoX/Dimensions.xlsx]

(ooxml, embedded labels, table is Dim_Temps)

WHERE annee = Year(Today())-1 or annee = year(Today())

;

I have 3 problems :

1st exigence of my client is :  would like to create 1 dimension called "Periode" and values on this dimension :

2015-01

2015-02

2015-03

2015-04

2015-05

2015-06

2014-01

2014-02

2014-03

2014-04

2015-Q1

2015-Q2

2015-S1

2015-S2

2014-S1

2014-S2

This dimension its for use in "filter"

In your point of view its possible to create this specific value ? i tried but it was not a success


2nd : I try to have dynamic title


For exemple if my client filtered on ' 2014-04,2014-03' i would like to have ' analyse on year : 2014 and on month : April and March


'Analyse : ' & Subfield(GetFieldSelections(annee_mois),'-',1) & ' ' & subfield(concat(GetFieldSelections(annee_mois),','),'-',2)

it's ok for year but not for month and i dont understand why ?


2nd :Crosstab


In my crosstab my client wants to see specific order, so i used :


WildMatch(li_Magasin,'Lyon','*')

Now i would like to insert a row "TOTAL" above my first row. its cumulative sum by "li_magasin"*

i saw on forum this fonction

rangesum()

I hope you can help me, thank you for your time.

PS : sorry for my English

12 Replies
brunobertels
Master
Master

Hi

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

regards

Not applicable
Author

Hello,

Thank Bruno. Now my dashboard is finished.

Thank you all for your helps.

brunobertels
Master
Master

Hi

I'am glad to be able to help you

Bruno