Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Need help in straight table!

Dear All,

In a straight table i want to calculate(count) how many itemname of a mfacname is having scheme. Please do the needful in the attached document and attach it back.

Hope to get quick reply!

userid:0010012021, password: c2info99

10 Replies
lironbaram
Honored Contributor II

Need help in straight table!

hi

look at the table with the blue caption

hope its helps

Not applicable

Need help in straight table!

Hi,

Thanks for your help. I don't want to display the itemname in the dimensions. I just want how many itemname of particular manufacturer is having scheme. I just want count of itemname with scheme. Hope you understood my requirement!

Thanks and Regards,

Rikab

lironbaram
Honored Contributor II

Need help in straight table!

hi

so all you need to do is to remove the itemname from the dimensions

regards

liron

Not applicable

Need help in straight table!

Hi Liron!

I did the same as said but i think it is not working as expected. It think it is not showing the exact no of items. To check it you an create a list box for item name. Click on any rows in the report which you have created and count no of related rows in itemname list box. It is not matching!

Regards,

Rikab

Not applicable

Need help in straight table!

Hi,

maybe you need not to "sum(aggr(..." but "count(aggr(..."

MIlda.

lironbaram
Honored Contributor II

Need help in straight table!

hi rikab

in the example i have only one mfcname

and all the items dont have schemes

so i cant check your problem

if you can proide a file with the data in the print screen i'll check it/

Not applicable

Need help in straight table!

Hi,

In the attached document in "Top moving product with scheme" straight table it shows all the items with scheme. But when i select the "#MED INDIA (GENERAL)" in the sraight table created by you as per your straight table it says it has 169 items with scheme and as per my straight table it doesn't contain any items with scheme.

I think if i select some other mfacname other than this ( "#MED INDIA (GENERAL)") i think it shows the correct value. Let me know where we are going wrong!

Regards,

Rikab

lironbaram
Honored Contributor II

Need help in straight table!

hi rikab

you didnt attached new document ,

maybe you can give a user and password with more then one manfcname

i cant check your problem with out that

Not applicable

Need help in straight table!

Hi Roi!

There is not much changes when compared to the one which you have sent. You just need to add a list box of the field itemname. Anyawy have attached it for your reference. Hope to receive some solution from you soon!

Thanks and Regards,

Rikab

Community Browser