Excel Report format in QlikView

[Anonymous]

Hi Everyone,

I want to make this type of report in QlikView. Can anyone please help me to achieve this...

Thanks & Regards

Gulshan Rohilla

[nehasaxena]

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

[Anonymous]

Thanks Neha...

But i want to make the report in Straight table...

[OmarBenSalem]

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

[Anonymous]

Thanks for the reply Omar... !

Data is same as the screenshot above...here i can't find the option to attach the data