Firstly its totally possible to display the data as in the image using a Pivot table in Qliksense. Infant it would look more intuitive. Add a row with region and 2 columns with Category1 and Category 2. Now add all your measures. This will create a pivot table as shown in the image.
Now answering your Questions:
1) The data can be shown that way, but you cannot have dynamic values in the headings yet.
2) Are you looking for a mini chart in the pivot table? If so thats not possible using a pivot table. I would suggest you to go for an extension if its that important.
3) You can have as many filters as possible.
Thanks and Regards,
Hi Kishore use this script:
rowno() as Month,
'Q' & Ceil (rowno()/3) as Quarter
Let varMinDate = Num('01/01/1950');
Let varMaxDate = Num('31/12/2050');
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
TempDate AS [Date],
week(TempDate) As [Week],
Year(TempDate) As [Year],
Month(TempDate) As [Month],
Day(TempDate) As [Day],
YeartoDate(TempDate)*-1 as [CurYTDFlag],
YeartoDate(TempDate,-1)*-1 as [LastYTDFlag],
inyear(TempDate, Monthstart($(varMaxDate)),-1) as [RC12],
date(monthstart(TempDate), 'MMM-YYYY') as [MonthYear],
ApplyMap('QuartersMap', month(TempDate), Null()) as [Quarter],
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as [WeekYear],
WeekDay(TempDate) as [WeekDay]
Order By TempDate ASC;
store [Master Calendar] into [lib://WOC Debts Extracts/master_calander.qvd];
Drop Table TempCalendar;
Quick question: Can anybody tell me how to find the Max value of a column (which is part of Master item).
firstly, I am not sure how to put aggregation function for master item.
secondly, the master item already has a aggregation function i.e. count(A), A is a column. Count(A) will bring me 1, 2, 3, 4 values in a column.
I want to put Red color to Min value and Green color to Max value. How do I achieve this. please advise.