topic Re: Issue with set analysis in calculated dimension in QlikView

Issue with set analysis in calculated dimension

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

Hello everybody !

i am facing an issue with a calculated dimension.

I explain: I have a cross table with Article code, article description and Plant as dimension; i want to add NumContract as calculated dimension.

Num contract is displayed when startdate<date analysed <Enddate

startdate and enddate are variables that i have created and they are defined as follow :

startdate : date(start contract date ,'DD/MM/YYYY') start contract date : 41640 and enddate : date(end contract date,'DD/MM/YYYY')

My expression is like this but it doesn't work and i need help :

aggr(only({<[Date analysed]={">$(date(startdate))<$(date(enddate))"}>}[Num contrat]),[Num contrat],[Article code], [Article description],Plant)

Thanks for your help !

Re: Issue with set analysis in calculated dimension

sunny_talwar — Thu, 29 Jun 2017 12:03:40 GMT

May be this

aggr(only({<[Date analysed]={">$(=date(startdate))<$(=date(enddate))"}>}[Num contrat]),[Num contrat],[Article code], [Article description],Plant)

Re: Issue with set analysis in calculated dimension

Anonymous — Thu, 29 Jun 2017 12:09:32 GMT

I tried with equal but nothing happens

Re: Issue with set analysis in calculated dimension

prma7799 — Thu, 29 Jun 2017 12:12:19 GMT

Can you please share sample data.

Re: Issue with set analysis in calculated dimension

Anil_Babu_Samineni — Thu, 29 Jun 2017 12:12:48 GMT

How is your Date Analyzed format looks like?

Re: Issue with set analysis in calculated dimension

sunny_talwar — Thu, 29 Jun 2017 12:13:30 GMT

Would you be able to share a sample to take a look at this?

Re: Issue with set analysis in calculated dimension

Anonymous — Thu, 29 Jun 2017 12:30:54 GMT

I am not sure...even if I scramb data, i don't have permission to do that...

Re: Issue with set analysis in calculated dimension

Anonymous — Thu, 29 Jun 2017 12:31:59 GMT

Hello, sorry but i am not sur to be able to share sample data...that is the reason why i put all information in my subject description...

Re: Issue with set analysis in calculated dimension

sunny_talwar — Thu, 29 Jun 2017 12:32:17 GMT

May be mock up data in an Excel file and provide the expected output from that sample?

Re: Issue with set analysis in calculated dimension

Anonymous — Thu, 29 Jun 2017 12:32:18 GMT

Date analyzed has this format : DD/MM/YYYY

Re: Issue with set analysis in calculated dimension

Anil_Babu_Samineni — Thu, 29 Jun 2017 12:34:17 GMT

I wonder, Why do you need startdate and enddate in your scenario, Rather you can try like below

aggr(only(Num contrat]),[Article code], [Article description],Plant)

Re: Issue with set analysis in calculated dimension

Anonymous — Thu, 29 Jun 2017 12:42:22 GMT

because i need to display only data with data analyzed between startdate and enddate : this is the customer's need..

Re: Issue with set analysis in calculated dimension

Anonymous — Thu, 29 Jun 2017 12:54:54 GMT

I have tried to mock up data..

Re: Issue with set analysis in calculated dimension

Anonymous — Thu, 29 Jun 2017 12:55:22 GMT

please see sample above..

Re: Issue with set analysis in calculated dimension

sunny_talwar — Thu, 29 Jun 2017 13:02:22 GMT

startdate and enddate are fields and not variable? Do you make selection in them before you want to see an output in your table?

Re: Issue with set analysis in calculated dimension

Anonymous — Thu, 29 Jun 2017 13:07:35 GMT

Variables. i do only selection on date analyse

Re: Issue with set analysis in calculated dimension

antoniotiman — Thu, 29 Jun 2017 13:28:03 GMT

Hi,

what about change Set Analysis (calculated per chart) to If() (per Rows) like this

=If([Date analyse] >= Date([Début validité contrat]) and [Date analyse] <= Date([Fin validité contrat]), [Numéro contrat])

Re: Issue with set analysis in calculated dimension

Anil_Babu_Samineni — Thu, 29 Jun 2017 13:40:23 GMT

The reason i am asking you is i am not sure which value you are getting in text box when you use this

Date(startdate) and date(enddate), Can you show the image for these 2 expressions in text box

Re: Issue with set analysis in calculated dimension

Anonymous — Thu, 29 Jun 2017 13:46:37 GMT

I have posted sample data above finally and i put these variables in textbox. May be it will be easier for you to help.

Re: Issue with set analysis in calculated dimension

Anil_Babu_Samineni — Thu, 29 Jun 2017 13:49:21 GMT

I don't have qlik software due to vocation, May be sunny offer you better