Variable dependant on marked items

Sun, 29 Nov 2015 15:44:05 GMT

Dear All,

I am using QV to create a load file for another reporting tool. This load file has a date fields (D_DP, D_PE) in a format rrrr.mm . In my accounting data loaded to QV I have as well month variable and it would be cool to make the data in D_DP & D_PE dependant upon the no of marked months in my MONTH field, as per the below:

No of marked fields data shown in D_DP & D_PE

2 2015.01

3 2015.02

4 2015.03

...

13 2015.12

I know I can not necesarely choose 2,3,4, subsequent months, however if there is no simple way to control it, then I would live with this potential risk.

Can you please help with proper formula for D_DP and D_PE fields? So fat it is just ='2015.10' and I change it manually at loads for sifferent set of months.

I attach a picture of part of my table and MONTH variable

thanks a lot in advance for your hints

Re: Variable dependant on marked items

anlonghi2 — Sun, 29 Nov 2015 21:00:46 GMT

Hi Drazsor,

use GetSelectedCount(MONTH) to know the number of selected months and then use the value to show D_DP & D_PE

Best regards

Andrea

Re: Variable dependant on marked items

Mon, 30 Nov 2015 19:25:59 GMT

thanks a lot Andrea,

works perfectly

Best Regards

Robert

topic Re: Variable dependant on marked items in QlikView

Variable dependant on marked items

Re: Variable dependant on marked items

Re: Variable dependant on marked items