Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dushkee
Contributor
Contributor

Pivot table - Columns with different dates

Hello 

i have pivot table and i need to add a column, where will be data only for a selected date period (from-to) and this column shouldnt consider the date selected in filter. 

Is there any possibility to fix the date in column1, column2 etc and the last row will be according to filter?

thanks

Labels (1)
1 Reply
mfchmielowski
Creator II
Creator II

Hi.

You can use datePickers and two variables. First DatePicker will set value to variable startDate and second DatePicker will set value to endDate variable. Then in expression of the pivot you can use SetAnalysis expression:

count({< dateColumn={">=$(dateStart)<=$(dateEnd)"} >} column)