Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gulshanrohilla
Contributor

Excel Report format in QlikView

Hi Everyone,

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

report format in QlikView.PNG

Thanks & Regards

Gulshan Rohilla

Tags (1)
4 Replies
nehasaxena
Contributor II

Re: Excel Report format in QlikView

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

gulshanrohilla
Contributor

Re: Excel Report format in QlikView

Thanks Neha...

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

omarbensalem
Esteemed Contributor

Re: Excel Report format in QlikView

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

gulshanrohilla
Contributor

Re: Excel Report format in QlikView

Thanks for the reply Omar... !

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