Welcome to Qlik Community

hi experts ,

i have a requirement on dates 

Requirement : I have two date columns "repotted on date" and "effective date " when i select Reporeted on date on UI then i need to show 13 months sales from effective date 

Example: when i select  "repotted on date"= '01-AUG-21' then data should show effective_date between '01-Aug-19' and '31-Jul-20' sales .

Thanks in advance ....

Thanks,

Siddiq

Hi All,

Have a  situation where I have to develop a qlikview application which will dynamically load multiple qvds depending upon selected month.

Files are stored as:

Jan21.qvd

Feb21.qvd

.

.

.Dec21.qvd

Depending on the Month selected from Drop down list corresponding month qvd should Load and display the values in the calculated fields.  please help me with this

Thank You

Hello all,

This is with regard to set analysis :

count({$<Country = {"sum({$<Week = {">$(=$(vTest))"}>}Sales) > 1000"}>}distinct Country)

The double quotes doesn't  work inside the element set , with single quote output is not correct

Hello All,

I have created a drill down dimension in qliksense like below :-

But when I am passing this dimension in chart, it is not working . Please see below :-

In Bar chart , i am unable to toggle to other dimension. Similarly when I take this drill down dimension in table , it is coming as a single field only . Am i doing something wrong ? Please suggest.

Thanks is advance

Hi all!

Today I faced with the following issue: 

1) In one Qlik Sense app we have "Report toolkit" chart which allow users to select any dimensions and metrics from the list and create their own report: 

2) All fields by default are hide and are displayed based on the rule in the "Show column if" field: 

3) Currently in this report we have 170 columns. And when I try to add new column I am not able to do this: it is shown as empty and after close the editing this change isn't saved: 

The problem is also in the fact that I am even not able to make some changes with existing items (for example to change "Show column if" rule). 

Qlik experts please help me with the following: 

1) Has anyone come across a limit on the maximum number of columns in a Qlik Sense straight table?

Maybe after some of the last releases... Our current Qlik Sense version is May 2021 Patch 4.  

2) What solutions could be in my case when I need to add new columns to the straight table with 170 existing columns? 

Hi all,

I Created Startdate and EndDate variables using the below definitions.

vStartDate1 as "=max({<StartDate = {"$(=min(StartDate))"}>} StartDate)"

vEndDate1 as "=Min({<EndDate = {"$(=min(EndDate))"}>} EndDate)"

I have selected dates as below but the data is not getting filtered correctly.

here is the expression used for match date in the table.

=if(timestamp(timestamp#([Match Date],'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm')>='$(vStartDate1)' and timestamp(timestamp#([Match Date],'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm')<='$(vEndDate1)',[Match Date])

here is the script that I used to generate data from 2017.

let vStartDate=Timestamp(AddMonths(now(),-48),'YYYY-MM-DD hh:mm:ss');
let vEndDate=Timestamp(now(),'YYYY-MM-DD hh:mm:ss');
trace $(vmindate);

LET vMinDate = num(Timestamp(Timestamp#(now()))-1468);

LET vMaxDate = num(Timestamp(Timestamp#(now())));

LET vNumberOfDays = Floor($(vMaxDate)) - Floor($(vMinDate)) + 1;

Calendar_Date_1Months:
LOAD

Timestamp(Num($(vMaxDate)) - (RecNo())/24/60 ) as Date,
Num(Floor(Date(Num($(vMaxDate)) - RecNo()/24/60 ))) as DateKey
AutoGenerate 24*60* $(vNumberOfDays) ;

StartDate:

LOAD Distinct
Timestamp((Date),'DD/MM/YYYY hh:mm') as StartDate
Resident Calendar_Date_1Months
order by DateKey desc;

EndDate:

LOAD Distinct
Timestamp((Date),'DD/MM/YYYY hh:mm') as EndDate
Resident Calendar_Date_1Months
order by DateKey desc;

MatchDate is in timestamped format. 

Could anyone please help me out on this.

Thanks

Sujana

@sunny_talwar 

Hello,
In an array, I have a dimension named 'CODE_NB' which I always want to display all the different values ​​regardless of:
- the year selected (0 if not used)
- the REEL or BUDGET summed indicator (0 if not used).

How to do this ?

Thank you very much,

Arnault