Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rpavan17
Creator
Creator

Total Volume..Year and Month wise on Qlikview

Volume.PNG

I would like to have number of reports in above table wise. ReportID is unique. Can anyone help on this.

Thanks!

6 Replies
shraddha_g
Partner - Master III
Partner - Master III

you can use expression as

Count(Distinct ReportID)

and Month & Year as Dimensions

rpavan17
Creator
Creator
Author

Hi Shraddha,

If i do in suggested way, I will get the all previous year data in same column. I am looking for the values as shown above.

Thanks..

shraddha_g
Partner - Master III
Partner - Master III

You will have to create Pivot Table.

you can have Row dimension as Month & Year as Column Filter

rpavan17
Creator
Creator
Author

Volume1.PNG

It is coming in the above way...

shraddha_g
Partner - Master III
Partner - Master III

in this Table you have Month-Year as One field.

You need to have Year as a Separate Field & Month as Separate one.

then you can create chart as required.

PrashantSangle

Hi,

do you have year and month field as 2 different field in back end.

If not then create it and use that field as dimension.

there is another way using calculated dimension.

1: subfield(MonthYear,'-',1)

2:subfield(MonthYear,'-',2)


Expression

Write your eexpression


Reards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂