Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I want to make this type of report in QlikView. Can anyone please help me to achieve this...
Thanks & Regards
Gulshan Rohilla
Hi Gulshan,
You need to use Pivot table object to display data in the required format.
If you could share sample data we could help more to achieve your requirement.
BR,
Neha
Thanks Neha...
But i want to make the report in Straight table...
Do you have any dummy data?
I think you can do that using ValueList.
As dimension:
ValueList('Receivable 1st-5th', 'Receivable 6th-10th')
as a measure:
if( ValueList('Receivable 1st-5th', 'Receivable 6th-10th') = 'Receivable 1st-5th' ,
sum( {<Day={">=01 <=05"} >} yourMeasure) , //this depends of what you have to calculate the 1st to 5th
sum( {<Day={">=06 <=10"} >} yourMeasure)
)
Try sthing like this; hope it helps.
Omar BEN SALEM
Thanks for the reply Omar... !
Data is same as the screenshot above...here i can't find the option to attach the data